SQL System Tables

Class

SQL Applications

Purpose

System-defined read-only views

See Also

DATA TYPES, SELECT

Description

System Tables are system defined read-only tables. You can query these tables using the SELECT statement. The following is an alphabetical reference of the System Tables accessible to all users.

Table	Remarks
SYSACTIVEUSERS	Description of currently active users on the system
SYSBESTROWIDENTIFIER	Description of a table’s optimal set of columns that uniquely identifies a row
SYSCATALOGS	Catalog names available in the database
SYSCOLUMNCONSTRAINTS	Description of the constraints for a table’s columns
SYSCOLUMNPRIVILEGES	Description of the access rights for a table’s columns
SYSCOLUMNS	Description of the table columns available in the catalog
SYSCROSSREFERENCE	Description of how one table imports the keys of another table
SYSEXPORTEDKEYS	Description of the foreign key columns that reference the primary key columns
SYSIMPORTEDKEYS	Description of the primary key columns that are referenced by the foreign key
SYSINDEXINFO	Description of a table’s indices and statistics
SYSIOSTATS	Facility for monitoring table and index file I/O operations
SYSLOGGING	System Logging information
SYSPRIMARYKEYS	Description of the primary key columns in the table
SYSPROCEDURECOLUMNS	Description of the input, output and results associated with certain stored procedures available
SYSPROCEDURES	Description of the stored procedures available in the catalog
SYSRESULTSET	Used to return the singleton result from any Recital expression
SYSSCHEMAS	Schema names available in the database
SYSTABLECONSTRAINTS	Description of the constraints for each table available in the catalog
SYSTABLEPRIVILEGES	Description of the access rights for each table available in the catalog
SYSTABLES	Description of the tables available in the catalog
SYSTABLETYPES	Table types available in the database system
SYSTYPEINFO	Description of all data types supported by the database
SYSUDTS	Description of the user-defined types (UDTs) defined in the schema
SYSVERSIONCOLUMNS	Description of the columns in a table that are automatically updated when any row is updated