一段用来查数据库各个表单的行数和存储的SQL语句
- WBOYOriginal
- 2016-06-07 15:23:561087browse
网上查到一段代码，用来查数据库中各个表的行数、存储大
网上查到一段代码，用来查数据库中各个表的行数、存储大小。优势非常有用。我们在SQ72008试过，在SQL7则要稍加改动。
出处忘了，抱歉了。
?
CREATE TABLE #temp (
table_name sysname ,
row_count INT,
reserved_size VARCHAR(50),
data_size VARCHAR(50),
index_size VARCHAR(50),
unused_size VARCHAR(50))
SET NOCOUNT ON
INSERT #temp
EXEC sp_msforeachtable 'sp_spaceused ''?'''
SELECT a.table_name,
a.row_count,
COUNT(*) AS col_count,
a.data_size
FROM #temp a
INNER JOIN information_schema.columns b
ON a.table_name collate database_default
= b.table_name collate database_default
GROUP BY a.table_name, a.row_count, a.data_size
ORDER BY CAST(REPLACE(a.data_size, ' KB', '') AS integer) DESC
DROP TABLE #temp
GO
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：数据库中NOLOGGING和FORCELOGGING的理解Next article：如何恢复一个只有完好数据文件的数据库？