Query table occupy space size

DECLARE

@sql as NVARCHAR(+),

@schmeaname as sysname,

@tablename as sysname;

DECLARE C CURSOR fast_forward for

SELECT table_schema,table_name

From information_schema. Tables

WHERE table_type = ' BASE table '

OPEN C

FETCH NEXT from C to @schmeaname,@tablename;

While @ @FETCH_STATUS = 0

BEGIN

SET @sql =

n ' EXEC sp_spaceused n ' '

+ QUOTENAME(@schmeaname)  + N '. '

+ QUOTENAME(@tablename) +N ";";

EXEC(@sql);

FETCH NEXT from C to @schmeaname,@tablename ;

END

CLOSE C;

deallocate C;

650) this.width=650; "src="/e/u261/themes/default/images/spacer.gif "border=" 0 "style=" Background:url ("/e/u261/ Lang/zh-cn/images/localimage.png ") no-repeat center;border:1px solid #ddd;" alt= "Spacer.gif"/>

This article is from the "Data Domain" blog, so be sure to keep this source http://charlist.blog.51cto.com/1616209/1697478

Query table occupy space size