欧美性猛交XXXX免费看蜜桃,成人网18免费韩国,亚洲国产成人精品区综合,欧美日韩一区二区三区高清不卡,亚洲综合一区二区精品久久

EXEC sp_spaceused 表名   可以查詢(xún)表的數據量和容量等信息，
循環(huán)查詢(xún)數據庫下表的的數據量和容量等信息用一下代碼：

if exists(select * from tempdb..sysobjects where id=object_id('tempdb..#spaceused'))
begin
drop table #spaceused
end

create table #spaceused (
  name varchar(40),
  rows char(11),
  reserced varchar(18),
  date varchar(18),
  index_size varchar(18),
  unuesd varchar(18)
)
declare @cursor cursor
declare @name varchar(40)
set @cursor = cursor for
   select
    name
   from
    sysobjects
   where
    xtype = 'U'
open @cursor
fetch next from @cursor into @name
while @@fetch_status = 0
begin
  insert into #spaceused
  EXEC sp_spaceused @name


  fetch next from @cursor into @name
end

select * FROM #SPACEUSED