枚举数据库中没有记录的表。 无 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 emptyrowswhere [totalrows] = 0