The catalog includes the views and tables in the SYSIBM
library displayed in this section.
SQLCOLPRIVILEGES
The SQLCOLPRIVILEGES view contains one row for every privileges
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.
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.