Could not drop object 'student' because it is referenced by a FOREIGN KEY constraint

来源:互联网 发布:手机c语言编辑器 编辑:程序博客网 时间:2024/05/16 06:20

1. Find foreign keys

SELECT* FROM sys.foreign_keysWHERE referenced_object_id = object_id('Student')

2. Delete foreign keys

SELECT    'ALTER TABLE ' +  OBJECT_SCHEMA_NAME(parent_object_id)+    '.['+ OBJECT_NAME(parent_object_id)+     '] DROP CONSTRAINT '+ nameFROM sys.foreign_keysWHERE referenced_object_id= object_id('Student')

0 0
原创粉丝点击