--查询数据库中所有表名
select name from sysobjects where xtype='u'
或
select * from sys.tables
--查询数据库中所有表名和行数
use [db_name]
go
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
a.name as 表名,
max(b.rows) as 记录条数
from sysobjects a ,sysindexes b
where a.id=b.id and a.xtype='u'
group by a.name
order by max(b.rows) desc
或
select schema_name(t.schema_id) as [ Schema ], t. name as TableName,i. rows as [RowCount]
from sys.tables as t, sysindexes as i
where t.object_id = i.id and i.indid <=1
