Get Record count of all tables of current database

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Sudhir Chawla » Get Record count of all tables of current...

Get Record count of all tables of current database

Rate Topic

Display Mode

Topic Options

Author

Message

Sudhir-192949

Posted Thursday, November 06, 2008 4:23 PM

SSCommitted

Group: General Forum Members
Last Login: Wednesday, January 16, 2013 4:11 AM
Points: 1,569, Visits: 56

Comments posted to this topic are about the item Get Record count of all tables of current database

Post #598605

mickabe

Posted Thursday, January 29, 2009 2:10 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, May 13, 2013 2:38 PM
Points: 9, Visits: 99

Ok for small db's but this is lightning quick and avoids cursors/looping...

select o.name, i.rows
from sys.sysobjects o with (nolock)
join sys.sysindexes i with (nolock)
on o.id = i.id
where i.indid < 2
order by i.rows desc, o.name

http://msdn.microsoft.com/en-us/library/ms190283.aspx

Post #646392

« Prev Topic | Next Topic »

Permissions