当前位置: 代码迷 >> Sybase >> Sybase 查看与目标表有外键联系关系的表名称
  详细解决方案

Sybase 查看与目标表有外键联系关系的表名称

热度:9060   发布时间:2013-02-26 00:00:00.0
Sybase 查看与目标表有外键关联的表名称
目标表为:TestTable

select sysobjects.name FK_Name,a.*from (select constrid,sysreferences.tableid,a.name as tablename,sysreferences.reftabid,b.name as reftabname	from sysreferences   LEFT OUTER join sysobjects a on sysreferences.tableid = a.id   LEFT OUTER join sysobjects b on sysreferences.reftabid = b.id  ) a,sysobjectswhere a.constrid = sysobjects.id  and (tableid = object_id('TestTable') or reftabid=object_id('TestTable'))