use [yourdbname] -- replace your dbname go select s.name as schemaname, t.name as tablename, p.rows as rowcounts, cast(round((sum(a.used_pages) / 128.00), 2) as numeric(36, 2)) as used_mb, cast(round((sum(a.total_pages) - sum(a.used_pages)) / 128.00, 2) as numeric(36, 2)) as unused_mb, cast(round((sum(a.total_pages) / 128.00), 2) as numeric(36, 2)) as total_mb from sys.tables t inner join sys.indexes i on t.object_id = i.object_id inner join sys.partitions p on i.object_id = p.object_id and i.index_id = p.index_id inner join sys.allocation_units a on p.partition_id = a.container_id inner join sys.schemas s on t.schema_id = s.schema_id group by t.name, s.name, p.rows order by s.name, t.name go
结果：