Managing primary keys (Sybase Central)

You can manage primary keys by using Sybase Central to help improve query performance on a table.

Prerequisites

You must be the owner of the table, or have one of the following privileges:

ALTER ANY OBJECT system privilege
ALTER ANY INDEX and ALTER ANY TABLE system privileges
ALTER and REFERENCES privileges for the table along with one of COMMENT ANY OBJECT, CREATE ANY OBJECT, or CREATE ANY TABLE system privileges

Right-click the table, and choose one of the following options:

Option	Action
Create or alter a primary key	Click Set Primary Key and follow the instructions in the Set Primary Key Wizard.
Delete a primary key	In the Columns pane of the table, clear the checkmark from the PKey column and then click Save.

Results

A primary key is added, altered, or deleted.