Managing primary keys

ASA SQL User's Guide
Working with Database Objects
Working with tables

Managing primary keys

The primary key is a unique identifier that is comprised of a column or combination of columns with values that do not change over the life of the data in the row. Because uniqueness is essential to good database design, it is best to specify a primary key when you define the table.

This section describes how to create and edit primary keys in your database. You can use either Sybase Central or Interactive SQL to perform these tasks.

Column order in multi-column primary keys

Primary key column order is determined by the order of the columns during table creation. It is not based on the order of the columns as specified in the primary key declaration.

Managing primary keys (Sybase Central)
Managing primary keys (SQL)