EXA_SCHEMAS

This system table lists all the schemas of the database to which the current user has access. Identical to EXA_ALL_SCHEMAS. 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