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

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')

原文地址:https://www.cnblogs.com/mfrbuaa/p/4020512.html