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.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|