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.


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


  • 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


  • 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:

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.