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 |