SQLserver 查询表是否被哪些存储过程和视图引用

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 '%表名%'

4 查询某字段在那些表里使用

select [name] from [库名].[dbo].sysobjects where id in(select id from [库名].[dbo].syscolumns Where name='字段名')