SYSSCHEMAS System Table

The SYSSCHEMAS table describes the schemas within the current database. It belongs to the SYS schema.

The following table shows the contents of the SYS.SYSSCHEMAS system table.

SYSSCHEMAS system table
Column Name Type Length Nullable Contents
SCHEMAID CHAR 36 NO Unique identifier for the schema
SCHEMANAME VARCHAR 128 NO Schema name
AUTHORIZATIONID VARCHAR 128 NO The authorization identifier of the owner of the schema

Usage Restrictions

Access to the SYS schema is restricted, for security purposes, to users for whom you Database Administrator has explicitly granted access. However, there is a corresponding   SYSVW.SYSSCHEMASVIEW system view, that allows you to access those parts of the table to which you have been granted access.

You can only query this system table if you have both ACCESS and SELECT privilege on the table; your database administrator may have to GRANT you these privileges.

If you don’t have access to this system table, you can use the view instead. Note that performance is better when using a table instead of its corresponding view. You can determine if you have access to this table by running the following command:

splice> DESCRIBE SYS.SYSSCHEMAS;

If you see the table description, you have access; if, instead, you see a message stating that “No schema exists with the name SYS,”  you don’t have access to the table; use the SYSVW.SYSSCHEMASVIEW system view instead.

Usage Example

Here’s an example of using this table:

SELECT * FROM SYS.SYSSCHEMAS;