Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Usage » Ensuring Data Integrity

Dropping domains Next Page

Enforcing entity and referential integrity


The relational structure of the database enables the database server to identify information within the database, and ensures that all the rows in each table uphold the relationships between tables (described in the database structure).


Enforcing entity integrity
If a client application breaches entity integrity
Primary keys enforce entity integrity
Enforcing referential integrity
Foreign keys enforce referential integrity
Losing referential integrity
If a client application breaches referential integrity
Referential integrity actions
Referential integrity checking