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. 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.

Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1