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

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