枚举数据库中没有记录的表。 无 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
枚举数据库中没有记录的表。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