SQL - List the tables in a database

October 2016


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!

Related :

This document entitled « SQL - List the tables in a database » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.