Click here to Skip to main content
Click here to Skip to main content
Articles » Database » Database » General » Alternatives
 
Go to top

Record Count of Tables in SQL Server

, 26 Aug 2010
Also use either this one:SELECT OBJECT_NAME(SYSINDEXES.id), SYSINDEXES.rowcntFROM SYSINDEXES INNER JOIN SYSOBJECTS ON SYSINDEXES.id = SYSOBJECTS.idWHERE SYSINDEXES.indid < 2 AND SYSOBJECTS.xtype = 'U'or this one:SELECT OBJECT_NAME(id),rowcnt FROM SYSINDEXES WHERE...

Alternatives

Members may post updates or alternatives to this current article in order to show different approaches or add new features.

19 Feb 2010
Md. Marufuzzaman
This is good... You can also consider this link.[^]
16 Aug 2011
Graham Cottle
Sometimes it is necessary to have the schema name included as well. I concatenate with the table name for my convenience, but it is not vital to do so.SELECT sys.sysindexes.rows, sys.schemas.name + '.' + sys.objects.nameFROM sys.objectsINNER JOIN sys.schemasON ...
16 Aug 2011
thatraja
4 alternatives  
The below query can be used to get the record count of all tables in the current database.
26 Aug 2010
Pranay Rana
Number of different ways to get total number of rows from tables

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

tarun_j200

India India
No Biography provided

| | Privacy | Mobile
Web02 | 2.8.140922.1 | Last Updated 26 Aug 2010
Article Copyright 2010 by tarun_j200
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid