SQL Cache Tables

All of the SQL Cache dynamic system tables have an authid of SYSADM.

All SQL Cache tables are prefixed with SQLSC, to represent SQL Source Cache.

Users can operate on the Cache by writing queries against the DSTs of the Cache.

Each column name is prefixed with the three-character table name abbreviation. All abbreviations consist of "SC" and a single character unique to the table.

Each table has a Primary Key consisting of a single, system-generated unique value. Use this column to join to related tables. The value of these Primary Keys can change each time the MUF is restarted.

Except where noted, these SQL Cache DSTs are read-only.

Following are descriptions of the Cache DSTs: