---==============查看数据库表的容量大小========start================================?============Create Table #TableSpaceInfo --创建结果存储表 (  NameInfo NVarchar(50) ,   RowsInfo int ,   Reserved NVarchar(20) ,   DataInfo NVarchar(20) ,   Index_Size NVarchar(20) ,   Unused NVarchar(20) )Declare @TableName NVarchar(255) --表名称Declare @CmdSql NVarchar(1000)Declare Info_Cursor Cursor ForSelect o.Name From dbo.sysobjects o Where objectProperty(o.ID, N‘IsTable‘) = 1 and o.Name not like N‘#%%‘ Order By o.NameOpen Info_CursorFetch Next From Info_Cursor Into @TableNameWhile @@FETCH_STATUS = 0 Begin  If exists (Select * From dbo.sysobjects Where ID=object_ID(@tablename) and objectProperty(ID, N‘IsUserTable‘) = 1)     Execute sp_executesql N‘Insert Into #TableSpaceInfo Exec sp_Spaceused @TBName‘, N‘@TBName NVarchar(255)‘, @TBName = @TableName  Fetch Next From Info_Cursor   Into @TableName EndClose Info_Cursor Deallocate Info_cursor GO--itlearner注：显示数据库信息 sp_spaceused @UpdateUsage = ‘TRUE‘--itlearner注：显示表信息 Select * From #TableSpaceInfo Order By cast(left(lTrim(rTrim(Reserved)) , len(lTrim(rTrim(Reserved)))-2) As Int) DescDrop Table #TableSpaceInfo---================查看数据库表的容量大小=====end========================?==========================