Home » Default » 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)

标签: SqlServer 查询空表

添加新评论

V