ODBC and JDBC catalog views

The catalog includes the following views and tables in the SYSIBM library:

View Name Description
SQLCOLPRIVILEGES Information about privileges granted on columns
SQLCOLUMNS Information about column attributes
SQLFOREIGNKEYS Information about foreign keys
SQLPRIMARYKEYS Information about primary keys
SQLPROCEDURECOLS Information about procedure parameters
SQLPROCEDURES Information about procedures
SQLSCHEMAS Information about schemas
SQLSPECIALCOLUMNS Information about columns of a table that can be used to uniquely identify a row
SQLSTATISTICS Statistical information about tables
SQLTABLEPRIVILEGES Information about privileges granted on tables
SQLTABLES Information about tables
SQLTYPEINFO Information about the types of tables
SQLUDTS Information about built-in data types and distinct types