SQLServer查看一个库里所有表的数据量

SELECT a.name TableName,b.rows TotalCount,D.Description AS [Description]

FROM 
			sysobjects a  
INNER JOIN	sysindexes b ON a.id=b.id   
join 


(
		select a.name AS name,isnull(g.[value],'未定义') AS Description
		from sys.tables a left join (SELECT * FROM sys.extended_properties WHERE NAME='Description' ) g	on (a.object_id = g.major_id AND g.minor_id = 0) 
) D				
						ON D.name = A.name
WHERE b.indid IN(0,1) AND a.Type='U'  and a.name not in ('')
ORDER BY b.rows  desc

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!