查看数据库中各表信息

use DBName

DECLARE @tablespaceinfo TABLE (
nameinfo varchar(50),
rowsinfo int,
reserved varchar(20),
datainfo varchar(20),
index_size varchar(20),
unused varchar(20)
)

DECLARE @tablename varchar(255);

DECLARE Info_cursor CURSOR FOR
SELECT [name] FROM sys.tables WHERE type='U';

OPEN Info_cursor
FETCH NEXT FROM Info_cursor INTO @tablename

WHILE @@FETCH_STATUS = 0
BEGIN
insert into @tablespaceinfo exec sp_spaceused @tablename
FETCH NEXT FROM Info_cursor
INTO @tablename
END

CLOSE Info_cursor
DEALLOCATE Info_cursor

SELECT * FROM @tablespaceinfo
ORDER BY Cast(Replace(reserved,'KB','') as INT) DESC

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/1724534/viewspace-1033757/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/1724534/viewspace-1033757/