EXA_USER_SCHEMAS

This system table lists all the schemas that are owned by the current user. All users have access to the table.

Column Name Description
SCHEMA_NAME Name of the schema object
SCHEMA_OWNER Owner of the object
SCHEMA_OBJECT_ID ID of the schema object
SCHEMA_IS_VIRTUAL States whether this is a virtual schema
SCHEMA_COMMENT Comment on the object