SQL 查询某个表在哪些存储过程（SP）中被使用到
1.查询某个表被哪些存储过程(以下简称 SP)使用 :select distinct object_name(id) from syscomments where id in(select object_id from sys.objects where type='P') and text like'%TableName%'2.查找那些过程对该表做了更新操作：select distinct object_name(id) from syscomments where id in(select object_id from sys.objects where type='P') and text like'%update tablename%'3.查询当前数据库中所有SP：select name as 存储过程 from sysobjects where type = 'P'
SQL 查找某个字段在哪些表存在查询语句
SELECT a.*,b.IS_IDENTITY FROM INFORMATION_SCHEMA.COLUMNS a JOIN sys.columns b on a.COLUMN_NAME = 你需要查询的字段