首页 > 代码库 > SQL Server:统计数据库中每张表的大小

SQL Server:统计数据库中每张表的大小

create table tmp(    name varchar(50),    rowscount int,    reserved varchar(50),      data varchar(50),    index_size varchar(50),    unused varchar(50));  insert tmp(name, rowscount, reserved, data, index_size, unused) exec sp_MSforeachtable @command1="sp_spaceused ?";select * from tmp where name <> tmp order by namedrop table tmp ;

SQL Server:统计数据库中每张表的大小