SQL Server获取表的容量很简单！

复制CREATEPROCEDUREget_tableinfoAS   ifnotexists(select*fromdbo.sysobjectswhereid=object_id(N[dbo].[tablespaceinfo])andOBJECTPROPERTY(id,取表NIsUserTable)=1)    createtabletablespaceinfo--创建结果存储表    (nameinfovarchar(50),    rowsinfoint,reservedvarchar(20),    datainfovarchar(20),    index_sizevarchar(20),    unusedvarchar(20))    deletefromtablespaceinfo--清空数据表    declare@tablenamevarchar(255)--表名称    declare@cmdsqlvarchar(500)    DECLAREInfo_cursorCURSORFOR    selecto.name    fromdbo.sysobjectsowhereOBJECTPROPERTY(o.id,NIsTable)=1    ando.namenotlikeN#%%orderbyo.name    OPENInfo_cursor    FETCHNEXTFROMInfo_cursor    INTO@tablename    WHILE@@FETCH_STATUS=0 BEGIN    ifexists(select*fromdbo.sysobjectswhereid=object_id(@tablename)andOBJECTPROPERTY(id,NIsUserTable)=1)    executesp_executesql    Ninsertintotablespaceinfoexecsp_spaceused@tbname,    N@tbnamevarchar(255),    @tbname=@tablename    FETCHNEXTFROMInfo_cursor    INTO@tablename    END    CLOSEInfo_cursor    DEALLOCATEInfo_cursor    GO    1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30.31.

本文地址：http://www.bzuk.cn/html/375f6299562.html