sql server new users: Find All Empty Table in database -- sql server new users

Find All Empty Table in database

Richard Thayne
2/17/2005 4:57:46 PM

sql server new users:

I am looking for a way to find all the tables in my database that are empty.
I know how to do it on each one individually but that would take too long.
How can I do a mass find of all empty tables in my database? Thanks

Re: Find All Empty Table in database

Adam Machanic
2/17/2005 9:17:56 PM

Asked and answered in .programming -- please refrain from multiposting.

--
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--

[quoted text, click to view]