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