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

SQL Anywhere 11.0.0 » SQL Anywhere Server - SQL Usage » Designing and Creating Databases » Working with database objects » Working with tables » Managing primary keys


Managing primary keys (Sybase Central)

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.

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.