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 » Ensuring data integrity » Enforcing entity and referential integrity


Primary keys enforce entity integrity

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.