标题 | SQL语句枚举数据库中的空表 |
范文 | SQL语句枚举数据库中的空表: 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 |
随便看 |
|
在线学习网范文大全提供好词好句、学习总结、工作总结、演讲稿等写作素材及范文模板,是学习及工作的有利工具。