SQL - List the tables in a database

September 2017


How to get the list of table present in an Oracle database?


Use one of the following command:
  • To list all the tables related the current user:
    • SELECT table_name FROM user_tables;  
  • List the tables accessible by the user:
    • SELECT table_name FROM all_tables;  
  • List all the tables (ADMIN):
    • SELECT table_name FROM dba_tables; 
Thanks to tehoden for this tip!


Published by aakai1056. Latest update on September 17, 2013 at 05:25 AM by deri58.
This document, titled "SQL - List the tables in a database," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).