Win a copy of Cross-Platform Desktop Applications: Using Node, Electron, and NW.js this week in the JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

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

 
suresh sargar
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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..?
 
Consider Paul's rocket mass heater.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!