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

SQL Anywhere 12.0.1 » SQL Anywhere Server - SQL Usage » Tables, views, and indexes » Primary keys


Creating and modifying a primary key (Sybase Central)

You can create or modify a primary key for a table using Sybase Central. Primary keys can improve performance for any operation that involves querying data.


You must have DBA authority, owner of the table, or have permissions to modify the table.

Context and remarks

You are adding a primary key to improve performance, or altering a primary key to reflect changes in the underlying objects that the key references.

 Configure a primary key using Sybase Central
  1. Connect to the database using the SQL Anywhere 12 plug-in.

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

  3. Right-click the table and click Set Primary Key.

  4. Follow the instructions in the Set Primary Key Wizard.


The table definition is modified to include updated primary key information.



 See also