Losing referential integrity

Your database can lose referential integrity if someone:

Updates or drops a primary key value. All the foreign keys referencing that primary key would become invalid.
Adds a new row to the foreign table, and enters a value for the foreign key that has no corresponding primary key value. The database would become invalid.

SQL Anywhere provides protection against both types of integrity loss.

Send feedback about this page via email or DocCommentXchange