查数据库中的表,了解大体结构
时间:2021-07-01 10:21:17
帮助过:1人阅读
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
查数据库中的表,了解大体结构
标签: