List schemas in Vertica database

Query below lists all schemas in Vertica database. Query include default v_internal, v_catalog and v_monitor schemas.

If you want to list user only schemas use this script.

Query

select schema_id, 
       schema_name,
       u.user_name as owner,
       create_time,
       is_system_schema
from v_catalog.schemata s
join v_catalog.users u
     on s.schema_owner_id = u.user_id
order by schema_name;

Columns

  • schema_id - schema id, unique within the database
  • schema_name - name of the schema
  • owner - principal that owns this schema
  • create_time - date and time when schema was created
  • is_system_schema - indicate wheter schema is system schema or not

Rows

  • One row represents one schema in a database
  • Scope of rows: all schemas in a database, including default ones
  • Ordered by schema name

Sample results

Here is a view of database schemas in DBeaver:

0
There are no comments. Click here to write the first comment.