select name from sys.objects where [object_id] in(
select depid from sys.sysdepends
where id =(select object_id from sys.objects where name ='your table name'))
and type_desc ='USER_TABLE'
select depid from sys.sysdepends
where id =(select object_id from sys.objects where name ='your table name'))
and type_desc ='USER_TABLE'
显示有关数据库对象相关性的信息(例如,依赖表或视图的视图和过程,以及视图或过程所依赖的表和视图)。不报告对当前数据库以外对象的引用。语法
sp_depends [ @objname = ] 'object'
create table t1(ID int primary key )create table t2(ID int constraint FK_t2 foreign key references t1(ID))select
object_name(fkeyID),object_name(rkeyID)
from
sysforeignkeys
where
fkeyID=object_id('t2')