IBM i catalog tables and views
The IBM® i catalog includes the views and tables in the QSYS2 schema displayed in this section.
| Db2® for i name | Corresponding ANSI/ISO name | Description |
|---|---|---|
| SYSCATALOGS | CATALOGS | Information about relational databases |
| SYSCHKCST | CHECK_CONSTRAINTS | Information about check constraints |
| SYSCOLAUTH | COLUMN_PRIVILEGES | Information about column privileges |
| SYSCOLUMNS | COLUMNS | Information about column attributes |
| SYSCOLUMNS2 | Information about column attributes | |
| SYSCOLUMNSTAT | Information about column statistics | |
| SYSCONTROLS | Information about row permissions and column masks | |
| SYSCONTROLSDEP | Information about row permission and column mask dependencies | |
| SYSCST | TABLE_CONSTRAINTS | Information about all constraints |
| SYSCSTCOL | CONSTRAINT_COLUMN_USAGE | Information about the columns referenced in a constraint |
| SYSCSTDEP | CONSTRAINT_TABLE_USAGE | Information about constraint dependencies on tables |
| SYSFIELDS | Information about field procedures | |
| SYSFUNCS | ROUTINES | Information about user-defined functions |
| SYSHISTORYTABLES | Information about history tables | |
| SYSINDEXES | Information about indexes | |
| SYSINDEXSTAT | Information about index statistics | |
| SYSJARCONTENTS | Information about jars for Java™ routines | |
| SYSJAROBJECTS | Information about jars for Java routines | |
| SYSKEYCST | KEY_COLUMN_USAGE | Information about unique, primary, and foreign keys |
| SYSKEYS | Information about index keys | |
| SYSMQTSTAT | Information about materialized query table statistics | |
| SYSPACKAGE | Information about packages | |
| SYSPACKAGEAUTH | Information about package privileges | |
| SYSPACKAGESTAT | Information about package statistics | |
| SYSPACKAGESTMTSTAT | Information about the SQL statements in packages | |
| SYSPARMS | PARAMETERS | Information about routine parameters |
| SYSPARTITIONDISK | Information about partition disk usage | |
| SYSPARTITIONINDEXDISK | Information about index disk usage | |
| SYSPARTITIONINDEXES | Information about partition indexes | |
| SYSPARTITIONINDEXSTAT | Information about partition index statistics | |
| SYSPARTITIONMQTS | Information about partition materialized query tables | |
| SYSPARTITIONSTAT | Information about partition statistics | |
| SYSPERIODS | Information about periods | |
| SYSPROCS | ROUTINES | Information about procedures |
| SYSPROGRAMSTAT | Information about programs, service programs, and modules that contain SQL statements | |
| SYSPROGRAMSTMTSTAT | Information about SQL statements embedded in programs, service programs, and modules | |
| SYSREFCST | REFERENTIAL_CONSTRAINTS | Information about referential constraints |
| SYSROUTINEAUTH | ROUTINE_PRIVILEGES | Information about routine privileges |
| SYSROUTINEDEP | ROUTINE_TABLE_USAGE | Information about function and procedure dependencies |
| SYSROUTINES | ROUTINES | Information about functions and procedures |
| SYSSCHEMAAUTH | Information about schema privileges | |
| SYSSCHEMAS | Information about schemas | |
| SYSSEQUENCEAUTH | USAGE_PRIVILEGES | Information about sequence privileges |
| SYSSEQUENCES | Information about sequences | |
| SYSTABLEDEP | Information about materialized query table dependencies | |
| SYSTABLEINDEXSTAT | Information about table index statistics | |
| SYSTABAUTH | TABLE_PRIVILEGES | Information about table privileges |
| SYSTABLES | TABLES | Information about tables and views |
| SYSTABLESTAT | Information about table statistics | |
| SYSTRIGCOL | TRIGGER_COLUMN_USAGE | Information about columns used in a trigger |
| SYSTRIGDEP | TRIGGER_TABLE_USAGE | Information about objects used in a trigger |
| SYSTRIGGERS | TRIGGERS | Information about triggers |
| SYSTRIGUPD | TRIGGERED_UPDATE_COLUMNS | Information about columns in the WHEN clause of a trigger |
| SYSTYPES | USER_DEFINED_TYPES | Information about built-in data types and distinct types |
| SYSUDTAUTH | UDT_PRIVILEGES | Information about type privileges |
| SYSVARIABLEAUTH | Information about global variable privileges | |
| SYSVARIABLEDEP | Information about objects used in global variables | |
| SYSVARIABLES | Information about global variables | |
| SYSVIEWDEP | VIEW_TABLE_USAGE | Information about view dependencies on tables |
| SYSVIEWS | VIEWS | Information about definition of a view |
| SYSXSROBJECTAUTH | USAGE_PRIVILEGES | Information about XML schema privileges |
| XSRANNOTATIONINFO | Information about annotations | |
| XSROBJECTCOMPONENTS | Information about components in an XML schema | |
| XSROBJECTHIERARCHIES | Information about XML schema document hierarchy relationships | |
| XSROBJECTS | Information about XML schemas |