SYSTEM.ACCOUNT | Identifies the I/O usage of current database sessions. |
SYSTEM.CALL | Identifies current internal calls. |
SYSTEM.CHECKDEF | Contains the search condition defined for each table check
constraint. Contains the column name for each column check constraint. |
SYSTEM.COLAUTH | Identifies users and groups and their column update
and reference authorities. |
SYSTEM.COLDEFAULT | Describes the default value of each column
defined with a non-NULL default. |
SYSTEM.COLUMN | Contains the definition of each column in each table and view. |
SYSTEM.CONSTRAINT | Contains information on integrity constraints. |
SYSTEM.CONSTRAINTCOL | Contains information on the columns within
unique and referential constraints. |
SYSTEM.CONSTRAINTINDEX | Describes each unique and referential constraint
index. |
SYSTEM.COUNTER | Describes the status of internal system counters. |
SYSTEM.DBEFILE | Describes the characteristics of each DBEFile. |
SYSTEM.DBEFILESET | Decribes the characteristics of each DBEFileset. |
SYSTEM.GROUP | Describes each authorization group. |
SYSTEM.HASH | Describes each hash structure. |
SYSTEM.IMAGEKEY | Describes each Master and Detail Dataset key associated with TurboIMAGE databases attached to the DBE. |
SYSTEM.INDEX | Describes each index.
|
SYSTEM.INSTALLAUTH | Identifies users and authorization groups that have been granted INSTALL authority. |
SYSTEM.MODAUTH | Identifies users and groups and the programs they can run.
|
SYSTEM.PARAMDEFAULT | Describes the default value of each parameter
defined with a non-NULL default. |
SYSTEM.PARAMETER | Describes each parameter of each procedure.
|
SYSTEM.PARTITION | Contains partition information. |
SYSTEM.PLAN | Stores the result of one GENPLAN for each session.
|
SYSTEM.PROCAUTH | Identifies users and groups and the procedures they
can execute. |
SYSTEM.PROCEDURE | Describes each procedure. |
SYSTEM.PROCEDUREDEF | Contains the definition of each procedure.
|
SYSTEM.PROCRESULT | Describes procedure result columns.
|
SYSTEM.RULE | Describes each rule. |
SYSTEM.RULECOLUMN | Describes columns an update rule checks for. |
SYSTEM.RULEDEF | Contains the referencing, WHERE, and EXECUTE
PROCEDURE clause of each rule. |
SYSTEM.SECTION | Describes stored modules and views. |
SYSTEM.SETOPTINFO | Contains SETOPT settings for optimizing specific stored sections. |
SYSTEM.SPACEAUTH | Identifies users and groups and what DBEFileSets they can use when creating tables, or stored sections. |
SYSTEM.SPACEDEFAULT | Identifies the default DBEFileSet to use for a new table or stored section.
|
SYSTEM.SPECAUTH | Identifies users and groups who have special authorities. |
SYSTEM.TABAUTH | Identifies users and groups and table/view operations
they can perform. |
SYSTEM.TABLE | Contains a description of each table and view in the
DBEnvironment, including size, owner, and associated DBEFileSet. |
SYSTEM.TEMPSPACE | Defines the TempSpace locations. |
SYSTEM.TPINDEX | Describes third-party indexes used in TurboIMAGE databases attached to the DBE. |
SYSTEM.TRANSACTION | Identifies transactions. |
SYSTEM.USER | Identifies users currently using the database. |
SYSTEM.VIEWDEF | Contains the SELECT statement that created
each view defined in the system.
|