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_OBJECT_ID = O.OBJECT_ID
WHERE O.TYPE = ‘U’ AND F.TYPE = ‘F’;