ANS and ISO catalog views
There are two versions of some of the ANS and ISO catalog views. The version documented is the normal set of ANS and ISO views. A second set of views have names that are limited to no more than 18 characters and other than the view names are not documented in this book.
- AUTHORIZATIONS
The AUTHORIZATIONS view contains one row for every authorization ID. - CHARACTER_SETS
The CHARACTER_SETS view contains one row for every CCSID supported. - CHECK_CONSTRAINTS
The CHECK_CONSTRAINTS view contains one row for every check constraint. - COLUMN_PRIVILEGES
The COLUMN_PRIVILEGES view contains one row for every privilege granted on a column. Note that this catalog view cannot be used to determine whether a user is authorized to a column because the privilege to use a column could be acquired through a group user profile or special authority (such as *ALLOBJ). Furthermore, the privilege to use a column is also acquired through privileges granted on the table. - COLUMNS
The COLUMNS view contains one row for every column. - INFORMATION_SCHEMA_CATALOG_NAME
The INFORMATION_SCHEMA_CATALOG_NAME view contains one row for the relational database. - PARAMETERS
The PARAMETERS view contains one row for each parameter of a routine in the relational database. - REFERENTIAL_CONSTRAINTS
The REFERENTIAL_CONSTRAINTS view contains one row for each referential constraint. - ROUTINES
The ROUTINES view contains one row for each routine. - ROUTINE_PRIVILEGES
The ROUTINE_PRIVILEGES view contains one row for every privilege granted on a routine. Note that this catalog view cannot be used to determine whether a user is authorized to a routine because the privilege to use a routine could be acquired through a group user profile or special authority (such as *ALLOBJ). - SCHEMATA
The SCHEMATA view contains one row for each schema. - SQL_FEATURES
The SQL_FEATURES table contains one row for each feature supported by the database manager. - SQL_LANGUAGES
The SQL_LANGUAGES table contains one row for every SQL language binding and programming language for which conformance is claimed. - SQL_SIZING
The SQL_SIZING table contains one row for each limit supported by the database manager. - TABLE_CONSTRAINTS
The TABLE_CONSTRAINTS view contains one row for each constraint. - TABLE_PRIVILEGES
The TABLE_PRIVILEGES view contains one row for every privilege granted on a table. Note that this catalog view cannot be used to determine whether a user is authorized to a table because the privilege to use a table could be acquired through a group user profile or special authority (such as *ALLOBJ). - TABLES
The TABLES view contains one row for each table, view, and alias. - UDT_PRIVILEGES
The UDT_PRIVILEGES view contains one row for every privilege granted on a type. Note that this catalog view cannot be used to determine whether a user is authorized to a type because the privilege to use a type could be acquired through a group user profile or special authority (such as *ALLOBJ). - USAGE_PRIVILEGES
The USAGE_PRIVILEGES view contains one row for every privilege granted on a sequence or XML schema. Note that this catalog view cannot be used to determine whether a user is authorized to a sequence or XML schema because the privilege to use a sequence or XML schema could be acquired through a group user profile or special authority (such as *ALLOBJ). - USER_DEFINED_TYPES
The USER_DEFINED_TYPES view contains one row for each distinct type. - VARIABLE_PRIVILEGES
The VARIABLE_PRIVILEGES view contains one row for every privilege granted on a global variable. Note that this catalog view cannot be used to determine whether a user is authorized to a global variable because the privilege to use a global variable could be acquired through a group user profile or special authority (such as *ALLOBJ). - VIEWS
The VIEWS view contains one row for each view.
Parent topic: DB2 for i catalog views