为每个外键约束设置“更新级联"选项 [英] Set Update Cascade option for every foreign key constraint

问题描述

对于数据库中的每个外键约束，都需要将 更新规则设置为级联. />
可以通过创建规则来完成，但是可以在上设置 Cascade 而不丢弃或在SQL Server 2008中重新创建外键约束.

如果有 TSQL 可用，请告诉我.

提前谢谢. :)

It is required to set Update Rule to Cascade for every foreign key constraint in database.

It can be done by creating rule, but is it possible to set Cascade on without drop or recreating foreign key constraint in SQL Server 2008.

Please let me know, if any TSQL is available for that.

Thanks in advance.:)

推荐答案

您已阅读以下内容: http://www.mssqltips.com/sqlservertip/2365/sql -server-foreign-key-update-and-delete-rules/ [ http://social.msdn.microsoft.com/论坛/en-US/transactsql/thread/5cbc4174-8623-4955-8fd8-fec8772ced53 [

Have you read this: http://www.mssqltips.com/sqlservertip/2365/sql-server-foreign-key-update-and-delete-rules/[^]?

http://social.msdn.microsoft.com/forums/en-US/transactsql/thread/5cbc4174-8623-4955-8fd8-fec8772ced53[^]

这篇关于为每个外键约束设置“更新级联"选项的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！