sql service 查询分析数据库

查询各个表格的行数    表格名+行数

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

统计各个    表格名+字段名

SELECT ST.name AS tableName,SL.name ColumnName FROM SYSOBJECTS ST
 LEFT JOIN SYSCOLUMNS  SL ON OBJECT_ID(ST.name)=SL.id
 WHERE ST.TYPE=‘U‘
 ORDER BY ST.name

sql service 查询分析数据库

标签：表格   esc   sele   分析   nbsp   官网   size   span   查询