Record Count of Tables in SQL Server

tarun_j200

Rate me:

5.00/5 (2 votes)

26 Aug 2010CPOL

5.8K

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...

Revisions

Compare	Revision	Minor	Date	Status	Editor
	2 - publicly available	No	25-Aug-10 23:48	Available	tarun_j200

	1	No	25-Aug-10 23:43	Composing

License

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

Written By

tarun_j200

India

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Record Count of Tables in SQL Server

Revisions

License

Comments and Discussions