sqlserver获取表外键的SQL语句

select t1.name as clmnName,t2.rtableName as fkTbl,t2.name as fkClmn from (select col.name,f.constid as temp? from syscolumns col,sysforeignkeys f? where f.fkeyid=col.id? and f.fkey=col.colid? and f.constid in? ( select distinct(id)???? from sysobjects??? where OBJECT_NAME(parent_obj)='表名'??? and xtype='F'?? )? ) as t1,(select OBJECT_NAME(f.rkeyid) as rtableName,col.name,sysforeignkeys f? where f.rkeyid=col.id? and f.rkey=col.colid? and f.constid in? ( select distinct(id)??? from sysobjects?? ?where OBJECT_NAME(parent_obj)='表名'??? and xtype='F'? ) )?as t2 where t1.temp=t2.temp

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!