大家可以把下面的命令建成一個view
用起來就非常的方更,快速喔^^
SELECT sysobjects.name as TableName ,sysindexes.rows as Rows
FROM sysindexes
inner join sysobjects on sysindexes.id=sysobjects.id
where sysobjects.id >100 and indid in (0,1)
用起來就非常的方更,快速喔^^
SELECT sysobjects.name as TableName ,sysindexes.rows as Rows
FROM sysindexes
inner join sysobjects on sysindexes.id=sysobjects.id
where sysobjects.id >100 and indid in (0,1)
全站熱搜
留言列表