Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Usage » Tables, views, and indexes » Primary keys


Managing primary keys (Sybase Central)

You can manage primary keys by using Sybase Central to help improve query performance on a table.


You must be the owner of the table, or have one of the following privileges:

  • ALTER ANY OBJECT system privilege
  • ALTER ANY INDEX and ALTER ANY TABLE system privileges
  • ALTER and REFERENCES privileges for the table along with one of COMMENT ANY OBJECT, CREATE ANY OBJECT, or CREATE ANY TABLE system privileges
  1. In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the database.

  2. In the left pane, double-click Tables.

  3. Right-click the table, and choose one of the following options:

    Option Action
    Create or alter a primary key Click Set Primary Key and follow the instructions in the Set Primary Key Wizard.
    Delete a primary key In the Columns pane of the table, clear the checkmark from the PKey column and then click Save.


A primary key is added, altered, or deleted.

 See also