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.
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.
In the left pane, double-click Tables.
Right-click the table and choose Set Primary Key.
Follow the instructions in the Set Primary Key Wizard.
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|