|
A primary key is a column, or set of columns, that is used to uniquely identify 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.
In the left pane, open the Tables folder.
Select the table for which you want to create or modify the primary key, and choose File > Set Primary Key.
The Set Primary Key wizard appears.
Follow the instructions in the wizard to create or modify the primary key.
When you have finished configuring the primary key in the Set Primary Key wizard, select Finish.
The new primary key information is automatically saved for the table.