"When one update causes an update on another table, usually to enforce referential integrity." (Owen Williams, "MCSE TestPrep: SQL Server 6.5 Design and Implementation", 1998)
"An update operation that updates all related database rows or columns. Cascading updates are typically implemented using triggers or stored procedures." (Microsoft Corporation, "SQL Server 7.0 System Administration Training Kit", 1999)
"An operation that updates a primary key value that is referenced by foreign key columns in existing rows in other tables." (Anthony Sequeira & Brian Alderman, "The SQL Server 2000 Book", 2003)
"An update operation to a primary key value in the parent table that automatically updates all related foreign key values in the child table(s)." (Victor Isakov et al, "MCITP Administrator: Microsoft SQL Server 2005 Optimization and Maintenance (70-444) Study Guide", 2007)
"For relationships that enforce referential integrity between tables, the updating of all related records in the related table or tables when a record in the primary table is changed." (Microsoft, "SQL Server 2012 Glossary", 2012)
[cascading actions:] "Cascading delete or cascading update operations that either delete a row containing a Primary Key or updates a Primary Key value referenced by Foreign Key columns in existing rows in other tables. On a cascading delete, all the rows whose Foreign Key values reference the deleted Primary Key value are also deleted. On a cascading update, all the Foreign Key values are updated to match the new Primary Key value." (Thomas Moore, "EXAM CRAM™ 2: Designing and Implementing Databases with SQL Server 2000 Enterprise Edition", 2005)
No comments:
Post a Comment