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’;
sqlserver数据库生成删除所有外键约束的sql
最新推荐文章于 2024-07-26 09:15:09 发布