在sqlserver中“删除级联"的目的是什么? [英] What is the purpose of On Delete Cascade in sqlserver?

问题描述

能否给我一个sqlserver中的On Delete级联示例?

Can you give me an example of an On Delete cascade in sqlserver?

推荐答案

ON DELETE CASCADE

指定如果尝试删除其他表中现有行中外键引用的键的行，则包含这些外键的所有行也将被删除.如果还已在目标表上定义了级联引用动作，则将从那些表中删除的行也采用指定的级联动作.

参考: http://msdn.microsoft.com/en-us/library /aa933119(v=sql.80).aspx [ ^ ]

例如: http://rudesyle.wordpress.com/2008/01/28 /cascading-deletes-in-sql-server/ [ ^ ]

ON DELETE CASCADE

Specifies that if an attempt is made to delete a row with a key referenced by foreign keys in existing rows in other tables, all rows containing those foreign keys are also deleted. If cascading referential actions have also been defined on the target tables, the specified cascading actions are also taken for the rows deleted from those tables.

Ref:http://msdn.microsoft.com/en-us/library/aa933119(v=sql.80).aspx[^]

Example:http://rudesyle.wordpress.com/2008/01/28/cascading-deletes-in-sql-server/[^]

这篇关于在sqlserver中“删除级联"的目的是什么?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！