ODBC and JDBC catalog views
The catalog includes the views and tables in the SYSIBM library displayed in this section.
- SQLCOLPRIVILEGES
The SQLCOLPRIVILEGES view contains one row for every privilege granted on a column or a privilege granted on the column’s table. 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). - SQLCOLUMNS
The SQLCOLUMNS view contains one row for every column in a table, view, or alias. - SQLFOREIGNKEYS
The SQLFOREIGNKEYS view contains one row for every referential constraint key on a table. - SQLFUNCTIONCOLS
The SQLFUNCTIONCOLS view contains one row for every parameter of a function. The result of a scalar function and the result columns of a table function are also returned. - SQLFUNCTIONS
The SQLFUNCTIONS view contains one row for every function. - SQLPRIMARYKEYS
The SQLPRIMARYKEYS view contains one row for every primary constraint key on a table. - SQLPROCEDURECOLS
The SQLPROCEDURECOLS view contains one row for every parameter of a procedure. - SQLPROCEDURES
The SQLPROCEDURES view contains one row for every procedure. - SQLSCHEMAS
The SQLSCHEMAS view contains one row for every schema. - SQLSPECIALCOLUMNS
The SQLSPECIALCOLUMNS view contains one row for every column of a primary key, unique constraint, or unique index that can identify a row of the table. - SQLSTATISTICS
The SQLSTATISTICS view contains statistic information about a table. - SQLTABLEPRIVILEGES
The SQLTABLEPRIVILEGES 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 or view because the privilege to use a table or view could be acquired through a group user profile or special authority (such as *ALLOBJ). - SQLTABLES
The SQLTABLES view contains one row for every table, view, and alias. - SQLTYPEINFO
The SQLTYPEINFO table contains one row for every built-in data type. - SQLUDTS
The SQLUDTS view contains one row for every distinct type.
Parent topic: DB2 for i catalog views