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