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