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) 编辑 收藏 举报