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

Query

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

Columns

• table_name - name of the table

Rows

• 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