SqlServer 查询表、视图、存储过程被哪些引用

1.查询表、视图、存储过程在哪些视图、存储过程、函数中被使用

SELECT DISTINCT OBJECT_NAME(id) name
FROM    syscomments
WHERE   id IN ( SELECT  id
                FROM    sysobjects
                WHERE   type IN ( 'V', 'P' ,'TF') ) --V表示视图，P表示存储过程，TF表示函数
  AND (text LIKE '%表名或者视图名或者存储过程名%')

2.查询包含SPDM字段的列以及对应的表

SELECT  o.name as bname,
        C.name as lname
FROM    syscolumns C
          INNER JOIN sysobjects o ON o.id = C.id
  AND o.type = 'U'
WHERE   C.name LIKE '%SPDM%'

3.查询表名字包含KEHU的表

SELECT  distinct o.name as name
FROM    syscolumns C
          INNER JOIN sysobjects o ON o.id = C.id
  AND o.type = 'U'
WHERE    o.name LIKE '%KEHU%'