Contents Index Managing primary keys Managing primary keys (SQL)

ASA SQL User's Guide
  Working with Database Objects
    Working with tables
      Managing primary keys

Managing primary keys (Sybase Central)

In Sybase Central, the primary key of a table appears in several places:

The lists in both the table property sheet and on the Columns tab display the primary key columns (along with the non-key columns) in the order that they were created in the database. This may differ from the actual ordering of columns in the primary key.

To create and edit the primary key (Sybase Central)

  1. Open the Tables folder.

  2. In the left pane, select the desired table.

  3. In the right pane, click the Columns tab.

  4. Change the primary as desired.

    To make a column a primary key column, place a checkmark in the checkbox beside the column name. Clear the checkbox to remote the column from the primary key.


Contents Index Managing primary keys Managing primary keys (SQL)