List tables in Oracle schema

Queries below list tables in (A) your schema and (B) a specific schema you have access to.


A. List of tables in YOUR schema

select object_name as table_name
from user_objects
where object_type = 'TABLE' 
order by object_name

B. List of tables in SPECIFIC schema

select object_name as table_name
from all_objects t
where object_type = 'TABLE'
and owner = 'SCHEMANAME'
order by object_name


  • table_name - name of the table


  • One row represents one table
  • Scope of rows: all tables in the schema
  • Ordered by table name

Sample results

Result shows list of tables in INV schema of our test database:

You could also get this

Get this interactive HTML data dictionary in minutes with Dataedo.

See live HTML data dictionary sample

Try for free

Comments are only visible when the visitor has consented to statistics cookies. To see and add comments please accept statistics cookies.
There are no comments. Click here to write the first comment.