SQLServer枚举数据库中的空表

来源：意涩情感网

枚举数据库中没有记录的表。无 WITH EmptyRows AS( SELECT SUM(row_count) AS [TotalRows], OBJECT_NAME(OBJECT_ID) AS TableName FROM sys.dm_db_partition_stats WHERE index_id = 0 OR index_id = 1 GROUP BY OBJECT_ID)SELECT * FROM EmptyRowsWHERE [To

枚举数据库中没有记录的表。 <无> $velocityCount-->

WITH EmptyRows AS
(
 SELECT SUM(row_count) AS [TotalRows],
 OBJECT_NAME(OBJECT_ID) AS TableName
 FROM sys.dm_db_partition_stats
 WHERE index_id = 0 OR index_id = 1
 GROUP BY OBJECT_ID
)
SELECT * FROM EmptyRows
WHERE [TotalRows] = 0

显示全文

全部频道

SQLServer枚举数据库中的空表