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’;