How do I determine which tables are empty and which are not in a DB?

N Casey

New Member

Join Date: Sep 2010

Posts: 1
#1

How do I determine which tables are empty and which are not in a DB?

Sep 3 '10, 02:37 PM

The DB in question has 300 tables and I'm looking to copy to a backup DB only those tables which are populated. This backup will be refreshed on a daily basis.

Cheers,

Niven
Tags: None
NeoPa

Recognized Expert Moderator MVP

Join Date: Oct 2006

Posts: 32636
#2

Sep 6 '10, 03:14 PM

I only know to use :

Code:

SELECT COUNT(*) FROM [TableName]
Comment

Comment