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