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

SQL Anywhere 12.0.0 » SQL Anywhere Server - SQL Usage » Working with database objects » Managing primary keys


Manage primary keys (Sybase Central)

A primary key is a column, or set of columns, that is used to identify unique rows in a table. Primary keys are typically created at table creation time; however, they can be modified at a later time. In Sybase Central, you access the primary key for a table in one of two ways:

  • right-clicking the table and choosing Set Primary Key, which starts the Set Primary Key Wizard. The Set Primary Key Wizard also allows you to change the order of columns of an existing primary key.

  • selecting the table in the left pane, and then choosing the Constraints tab in the right pane.

 To configure a primary key (Sybase Central)
  1. Use the SQL Anywhere 12 plug-in to connect to the database as a user with DBA authority or as the owner of the table.

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

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

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