本文共 759 字,大约阅读时间需要 2 分钟。
select a.外键,b.tbl_nme as 主表,b.col_nme as 主列,c.tbl_nme as 参照表,c.col_nme as 参照列
from (select a.name as 外键,a.parent_object_id,b.parent_column_id,a.referenced_object_id,b.referenced_column_idfrom sys.foreign_keys aleft join sys.foreign_key_columns bon a.object_id=b.constraint_object_id ) as aleft join (select b.name as tbl_nme,a.name as col_nme,b.id as obj_id,a.colid from syscolumns a left join sysobjects bon a.id=b.idwhere b.xtype='u' ) bon a.parent_object_id=b.obj_id and a.parent_column_id=b.colid left join (select b.name as tbl_nme,a.name as col_nme,b.id as obj_id,a.colid from syscolumns a left join sysobjects bon a.id=b.idwhere b.xtype='u' ) con a.referenced_object_id=c.obj_id and a.referenced_column_id=c.colid where c.tbl_nme='main_per'转载地址:http://iwbmi.baihongyu.com/