我想要删除所有符合以下条件的外键。
SELECT CONSTRAINT_NAME
FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS
WHERE TABLE_NAME IN ('Table1', 'Table2')
AND CONSTRAINT_NAME LIKE '%FK__%__DL%'
SELECT * FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE CONSTRAINT_NAME = 'FK__Stock__DL3__6E0C4425'
- Siyavash HamdiSELECT TABLE_SCHEMA,TABLE_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE CONSTRAINT_NAME ='FK__Stock__DL3__6E0C4425'
。 然后尝试执行此查询:ALTER TABLE [TABLE_SCHEMA]。[TABLE_NAME] DROP CONSTRAINT [FK__Stock__DL3__6E0C4425]
。 是否可以删除?(不要忘记替换TABLE_SCHEMA
和TABLE_NAME
的名称! - Siyavash Hamdi