Queries below list tables in a specific schema.

Query

select table_schema,
       table_name,
       create_time
from v_catalog.tables
where table_schema = 'schema_name' -- put your schema name here
order by table_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

You could also get this

Get this interactive HTML data dictionary in minutes with Dataedo.

See live HTML data dictionary sample

Try for free