Sql Server中查詢數(shù)據(jù)庫所有表及其數(shù)據(jù)總條數(shù)和占用空間
1、查詢某數(shù)據(jù)庫中的所有數(shù)據(jù)表
SELECT name 數(shù)據(jù)表
FROM sysobjects
WHERE xtype='u'
ORDER BY name
2、查詢某數(shù)據(jù)庫中的所有數(shù)據(jù)表及其數(shù)據(jù)總條數(shù)
SELECT a.name 數(shù)據(jù)表,
b.rows 數(shù)據(jù)總條數(shù)
FROM sysobjects AS a
INNER JOIN sysindexes AS b ON a.id = b.id
WHERE ( a.type = 'u' )
AND ( b.indid IN ( 0, 1 ) )
ORDER BY a.name,b.rows DESC;
3、查詢某數(shù)據(jù)庫中的所有數(shù)據(jù)表及其數(shù)據(jù)總條數(shù)所占用的空間大小
SELECT OBJECT_NAME(id) 數(shù)據(jù)表,
RTRIM(8 * dpages) + 'KB' 占用空間大小,
rows 數(shù)據(jù)總條數(shù)
FROM sysindexes
WHERE indid = 1
ORDER BY rows DESC ,
數(shù)據(jù)表 ,
reserved DESC;
4、查詢數(shù)據(jù)庫文件路徑信息
select * from sys.database_files
5、查詢數(shù)據(jù)庫文件大小文章來源：http://www.zghlxwxcb.cn/news/detail-784562.html
--當(dāng)前數(shù)據(jù)庫服務(wù)器所有數(shù)據(jù)庫文件大小
SELECT DB_NAME(database_id) AS DatabaseName,
Name AS Logical_Name,
Physical_Name, (size*8.0)/1024 SizeMB
FROM sys.master_files
GO
--查看某一個數(shù)據(jù)庫的文件大小
SELECT DB_NAME(database_id) AS DatabaseName,
Name AS Logical_Name,
Physical_Name, (size*8.0)/1024 SizeMB
FROM sys.master_files
WHERE DB_NAME(database_id) = 'database數(shù)據(jù)庫名'
GO文章來源地址http://www.zghlxwxcb.cn/news/detail-784562.html
到了這里，關(guān)于Sql Server中查詢數(shù)據(jù)庫所有表及其數(shù)據(jù)總條數(shù)和占用空間的文章就介紹完了。如果您還想了解更多內(nèi)容，請在右上角搜索TOY模板網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章，希望大家以后多多支持TOY模板網(wǎng)！
![[SQL Server]數(shù)據(jù)庫入門之多表查詢](https://imgs.yssmx.com/Uploads/2024/02/477012-1.gif)
