22,209
社区成员
发帖
与我相关
我的任务
分享
select name from tempdb.dbo.sysobjects where xtype in('U','V')
--sql2000显示所有数据库对象的类别和大小
select count(name) num_instances ,type ,sum(source_size) source_size ,
sum(parsed_size) parsed_size ,sum(code_size) code_size ,sum(error_size) error_size,
sum(source_size) +sum(parsed_size) +sum(code_size) +sum(error_size) size_required
from dba_object_size
group by type order by 2