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’;
新聞熱點
疑難解答