sys.foreign_keys

查询一个表格的外键约束信息

select fk.name,fk.object_id, OBJECT_NAME(fk.parent_object_id) as referenceTableName
from sys.foreign_keys as fk
join sys.objects  as o on fk.referenced_object_id =o.object_id
where o.name=N'Product_inmem'