SQLServer 查找含有指定内容的表及存储过程

获取数据库所有表的表名及数据条数

SELECT a.name '数据库表名', b.rows '数据条数' 
FROM sysobjects AS a
INNER JOIN sysindexes AS b ON a.id = b.id
WHERE (a.type = 'u') AND (b.indid IN (0, 1))
ORDER BY b.rows DESC

根据列名‘timecode’ 查询表及其数据条数

SELECT a.name '数据库表名', column_name '列名', b.rows '数据条数'
FROM sysobjects AS a
INNER JOIN sysindexes AS b ON a.id = b.id
LEFT JOIN INFORMATION_SCHEMA.COLUMNS c on a.name = c.table_name
WHERE (a.type = 'u') AND (b.indid IN (0, 1)) AND COLUMN_NAME = 'timecode'
ORDER BY b.rows DESC

根据‘想要找的內容’ 查询含有内容存储结构

SELECT obj.Name 存储过程名, sc.TEXT 存储过程内容 
FROM syscomments sc 
INNER JOIN sysobjects obj ON sc.Id = obj.ID 
WHERE sc.TEXT LIKE '%想要找的內容%'