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.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|