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

时间:2021-07-30 17:59:48

1. Find foreign keys

SELECT
* FROM sys.foreign_keys
WHERE 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')