sqlserver数据库生成删除所有外键约束的sql
sqlserver数据库生成删除所有外键约束的sql
–生成禁用键约束SQL
SELECT
‘ALTER TABLE ’ + O.NAME + ’ NOCHECK CONSTRAINT ’ + F.NAME + ‘;’ AS COMMAND
FROM
SYS.FOREIGN_KEYS F INNER JOIN SYS.ALL_OBJECTS O ON F.PARENT_O
原创
2017-02-10 12:03:02 ·
2201 阅读 ·
1 评论