查询所有表的外键约束
select name from sysobjects where xtype='f'
查询所有表的外键约束,并显示该表信息
select OBJECT_NAME(sysobjects.parent_obj),* from sysobjects where xtype='f'
查询所有表的外键约束
select name from sysobjects where xtype='f'
查询所有表的外键约束,并显示该表信息
select OBJECT_NAME(sysobjects.parent_obj),* from sysobjects where xtype='f'