Checking for unused/empty tables

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

SQL Server 2000 Forums

Transact-SQL (2000)

Checking for unused/empty tables

Author

Topic

heygee
Starting Member

27 Posts

Posted - 2005-09-12 : 09:50:08

Hi,

I have a couple of large databases and wanted to know if there was a script available to check which of these databases have empty/blank tables.

TIA,
Gee

Gee

"Happiness is a good health and a bad memory!"

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-09-12 : 09:53:16

One of the ways is to use sysindexes althoght the result may not be perfect

select name ,rows from sysindexes where rows=0 and indid<2

Madhivanan

Failing to plan is Planning to fail

heygee
Starting Member

27 Posts

Posted - 2005-09-12 : 12:14:48

many thanks for the reply :)

Gee

"Happiness is a good health and a bad memory!"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources