The system table lists all schemas. Only users with the SELECT ANY DICTIONARY system privilege have access to the table.
| Column Name | Description |
|---|---|
SCHEMA_NAME
|
Name of the schema object |
SCHEMA_OWNER
|
Owner of the schema 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 |
