你的位置:首页 > 数据库

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


 

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