A simple and fast query to find the number of records/rows in every table in your database.
select t.name TableName, i.rows Records from sysobjects t, sysindexes i
where t.xtype = 'U' and i.id = t.id and i.indid in (0,1) order by 2 desc;
A simple and fast query to find the number of records/rows in every table in your database.
select t.name TableName, i.rows Records from sysobjects t, sysindexes i
where t.xtype = 'U' and i.id = t.id and i.indid in (0,1) order by 2 desc;