Remove_FK_Element.sql

SELECT * 
FROM sys.foreign_keys
WHERE referenced_object_id = object_id('tbl_Ingredients')

SELECT 
    'ALTER TABLE ' +  OBJECT_SCHEMA_NAME(parent_object_id) +
    '.[' + OBJECT_NAME(parent_object_id) + 
    '] DROP CONSTRAINT ' + name
FROM sys.foreign_keys
WHERE referenced_object_id = object_id('tbl_Ingredients')