1 被我引用的对象
SELECT * FROM sys.dm_sql_referenced_entities('TableName','OBJECT');
–查看依赖项
2 引用我的对象
SELECT * FROM sys.dm_sql_referencing_entities('TableName','OBJECT');
3 存储过程、视图引用
select distinct object_name(id) from syscomments where id in
(select id from sysobjects where type ='P') and text like '%表名%'