Checking if a table is empty using count

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Checking if a table is empty using count

Author

Topic

albaker
Starting Member

7 Posts

Posted - 2007-09-10 : 05:21:37

Hi,

I want to use something like select count(*) from table name = 0; to check whether a table is empty,

is this possible?

Thanks for any info.

Al.

PeterNeo
Constraint Violating Yak Guru

357 Posts

Posted - 2007-09-10 : 05:56:57

Try this, if all statistics are updated then only it wll give exact no of rows

Select so.[Name] as 'TblName', si.rows as 'Count'
From sys.sysobjects so
Inner join sys.sysindexes si On so.id = si.id
Where so.xtype = 'u'
and si.indid < 2
Order By si.rows

else u have to use dynamic sql with loop