Once you specify the primary key for each table, maintaining entity integrity requires no further action by either client application developers or by the database administrator.

The table owner defines the primary key for a table when they create it. If they modify the structure of a table at a later date, they can also redefine the primary key.

For more information about creating primary keys, see Managing primary keys.

For the detailed syntax of the CREATE TABLE statement, see CREATE TABLE statement.

For information about changing table structure, see ALTER TABLE statement.