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 |