--查看数据库表 行数,数据大小,占用空间
DECLARE @tmp table (
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 rowscount desc