查询数据库中有数据的表

--查询出有数据的表
CREATE TABLE #temp
(
TableName NVARCHAR (128), /*表明称*/
RowsCnt VARCHAR (11), /*数据的行数*/
ReservedSpace VARCHAR(18), /*预留空间*/
DataSpace VARCHAR(18), /*数据空间*/
CombinedIndexSpace VARCHAR(18), /**/
UnusedSpace VARCHAR(18) /*没用空间*/
)
EXEC sp_MSforeachtable'INSERT INTO #temp (TableName, RowsCnt, ReservedSpace,DataSpace, CombinedIndexSpace, UnusedSpace) EXEC sp_spaceused ''?'', FALSE'

SELECT TableName, RowsCnt,ReservedSpace, DataSpace, CombinedIndexSpace, UnusedSpace
FROM #temp where RowsCnt<>0
ORDER BY TableName

转载于:https://www.cnblogs.com/accumulater/p/6093358.html