-- 显示每个表当前有多少行 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 sysobjects.name ASC
to: DontWorry(不用當心)老大,能对你的代码做详细的解释吗?我是一个菜鸟
TOP 100 Percent这句是多余的,当初是为了写成一个试图都是系统表sysobjects.xtype = 'u' 表示 : 在系统对象表 中 那些用户表其他的没什么了
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 sysobjects.name ASC