[问题描述]

在SQL server数据库里如何查看临时表,查看系统所有临时表占用的总空间

[操作步骤]

1. 在SQL server数据库里如何查看临时表,执行下记SQL

   select * from sys.sysobjects where xtype='u' and name like 'tmp%'

2. 查看系统所有临时表占用的总空间,执行下记SQL

   select cast(sum(a.total_pages)*8/1024 as varchar)+' MB' total from sys.partitions p join sys.allocation_units a on p.partition_id = a.container_id join sys.tables it on p.object_id = it.object_id where it.name like 'TMP%'