sql 查询 空表

SELECT a.id, b.[name], a.ROWS FROM sysindexes a,
sys.tables b WHERE a.id = b.[object_id] AND a.indid <=1 and a.rows<1 ORDER BY b.[name]

posted on 2015-11-09 16:01  编程007  阅读(350)  评论(0编辑  收藏  举报