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 |
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.