查数据库中的表,了解大体结构

SELECT TOP 100 Percent  sysobjects.name,  sysindexes.rows FROM sysindexes with(nolock)  JOIN sysobjects with(nolock)  ON sysindexes.id = sysobjects.id AND sysobjects.xtype = 'u'WHERE sysindexes.indid in(0, 1) order by rows desc--何问起 hovertree.com

推荐：http://www.cnblogs.com/roucheng/p/GUID.html

原标题：查数据库中的表,了解大体结构

关键词：数据库