List user created schemas in Vertica database

This query returns list of user created, non-system schemas.


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
where schema_name != 'public'
      and is_system_schema = 'false'
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


  • One row represents one schema in a database created by user
  • Scope of rows: all user's schemas in a database
  • Ordered by schema name


  • One row represents one schema
  • Scope of rows: all user created schemas
  • Ordered by schema name

Sample results

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.