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