September 2010
Intermediate to advanced
1704 pages
111h 8m
English
Several options, including foreign key constraints and stored procedures, are available to enforce referential integrity, but using a trigger is still a viable alternative. A trigger provides a great deal of flexibility and allows you to customize your referential integrity solution to fit your needs. Some of the other alternatives, such as foreign keys, do not provide the same degree of customization.
In a database environment in which multiple databases are used with related data, a trigger can be invaluable for enforcing referential integrity. The trigger can span databases, and it can ensure that data rows inserted into a table in one database are valid based on rows in another database. ...