how to find all tablename and rowcount of each table from database?

Greenhorn

Posts: 12

posted 16 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

please help me for the query..

i want tablename and row count of each table.

i knew one query select table_name ,num_rows from user_tables;

but if i update some table that updated row count will be not gettting with this query...

can you suggest me any other query how to get updateable result..?

He loves you so much! And I'm baking the cake! I'm going to put this tiny ad in the cake:

Clean our rivers and oceans from home

https://www.kickstarter.com/projects/paulwheaton/willow-feeders