TABLE COUNT

Can someone tell me if theres a sql command that I can run that will tell me exactly how many tables are in my database?

Thanks

SELECT COUNT(*) FROM DBA_TABLES;

Thanks

is there another sql command that can tell me if the table is emtpy or not??

Thanks you guys are great I've learned a lot over the past month


Tim

Hi Please Issue this
exec dbms_utility.analyze_schema('yourschemaname','compute');

Then
Select count(*) from dba_tables
where row_num = 0;

Thanks..

Thanks Jmodic

Quote:

---

Originally posted by Oracledba8
Hi Please Issue this
exec dbms_utility.analyze_schema('yourschemaname','compute');

Then
Select count(*) from dba_tables
where row_num = 0;

Thanks..

---

Opps, it should be num_rows.

Take care