search

Home >Database >Mysql Tutorial >mssqlserver查看数据库中各表的占用空间情况

mssqlserver查看数据库中各表的占用空间情况

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
2016-06-07 17:48:481129browse

本文章分享一篇关于mssqlserver查看数据库中各表的占用空间情况有需要的同学可以看看。

查看中各表的占用空间情况:
 

 代码如下 复制代码
create table tablesize (name varchar(50),rows int,reserved varchar(50),
  data varchar(50),index_size varchar(50),unused varchar(50))
insert into tablesize (name,rows,reserved,
  data,index_size,unused) exec sp_msforeachTable @Command1="sp_spaceused '?'"
 
update tablesize set data=replace(data,'KB','')
 
*,convert(int,data) as a from tablesize order by A desc
 
drop table tablesize
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：mssqlserver中最大ID冲突解决办法Next article：mssqlserver中BULK INSERT大批量导入数据 SQL SERVER

Related articles

See more