Queries below list tables in a specific schema.
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;
- table_name - name of the table
- One row represents one table
- Scope of rows: all tables in the schema
- Ordered by table name
You could also get this
Get this interactive HTML data dictionary in minutes with Dataedo.
See live HTML data dictionary sample