Question

mssql 统计一个数据库中所有表记录的数量

如题，比如我建立一个名叫school数据库，里面有100多个表，我想准确的获取到表的数量，应该如何查询

Answer 1

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

Answer 2

Select count(*) FROM SysObjects Where XType='U'

Select Name FROM SysObjects Where XType='U' orDER BY Name