The SYS_INFO_SCHEMA contains system-specific data. It provides complete information on all SESAM/SQL objects. The SYS_INFO_SCHEMA may be changed in future versions of SESAM rendering it incompatible.
Only the universal user has access to the views of the SYS_INFO_SCHEMA. The universal user can pass on the SEELCT privilege to other users.
The following table indicates which views of the SYS_INFO_SCHEMA contain information on which database objects.
Object | View name | Information on |
Database | SYS_CATALOGS SYS_DBC_ENTRIES | Database all known databases |
Schema | SYS_SCHEMATA | Schemas in the database |
Table | SYS_TABLES SYS_PARTITIONS SYS_VIEW_USAGE SYS_CHECK_USAGE | Tables in the database Partitions in the database Tables on which the views are based Tables for which check constraints are defined |
Column | SYS_COLUMNS SYS_VIEW_USAGE SYS_CHECK_USAGE | Columns in the database Columns on which views are based Columns for which check constraints are defined |
Privilege | SYS_PRIVILEGES SYS_SPECIAL_PRIVILEGES SYS_USAGE_PRIVILEGES SYS_ROUTINE_PRIVILEGES | Table privileges Special privileges USAGE privileges Privileges for routines |
Index | SYS_INDEXES | Indexes in the database |
Integrity constraint | SYS_TABLE_CONSTRAINTS SYS_REFERENTIAL_CONSTRAINTS SYS_CHECK_CONSTRAINTS SYS_UNIQUE_CONSTRAINTS | Integrity constraints Referential constraints Check constraints UNIQUE constraints |
Storage group | SYS_STOGROUPS | Storage groups in the database |
Space | SYS_SPACES SYS_SPACE_PROPERTIES | Spaces Space properties |
Routines | SYS_PARAMETERS SYS_ROUTINES SYS_ROUTINE_ROUTINE_USAGE SYS_ROUTINE_USAGE SYS_ROUTINE_ERRORS SYS_VIEW_ROUTINE_USAGE | Parameters of routines Routines Routines in other routines Tables and columns in routines Error events in routines Routines in views |
SQL statements | SYS_DML_RESOURCES | “Costly” DML statements |
User | SYS_USERS SYS_SYSTEM_ENTRIES | Authorization identifier System entries |
DA-LOG file | SYS_DA_LOGS | DA-LOG files |
Media table | SYS_MEDIA_DESCRIPTIONS | Media records of the database-specific files |
Recovery unit | SYS_RECOVERY_UNITS | Recovery units for spaces |
Locks | SYS_LOCK_CONFLICTS | The lock conflicts which |
System environment | SYS_ENVIRONMENT | SESAM/SQL's operating system environment |
Table 107: Views of the SYS_INFO_SCHEMA (section 2 of 2)
The views of the SYS_INFO_SCHEMA are described in alphabetical order in the following sections.