SELECT 'ALTER TABLE '+ OBJECT_NAME(parent_object_id)+ ’ DROP CONSTRAINT ’ +Name FROM sys.foreign_keys WHERE referenced_object_id=OBJECT_ID(‘dbo.学生’)
SQL查询主键引用并拼成删除外键SQL语句
最新推荐文章于 2024-02-16 01:11:43 发布
SELECT 'ALTER TABLE '+ OBJECT_NAME(parent_object_id)+ ’ DROP CONSTRAINT ’ +Name FROM sys.foreign_keys WHERE referenced_object_id=OBJECT_ID(‘dbo.学生’)