SqlServer查询空表
SELECT schema_name(t.schema_id) AS [Schema], t.name AS TableName, i.rows AS [RowCount]
FROM sys.tables AS t INNER JOIN
sys.sysindexes AS i ON t.object_id = i.id
WHERE (i.indid <= 1) AND (i.rows = 0)