B. Dictionary Tables

This appendix lists the information stored in dictionary tables and the B-tree indexes defined for dictionary tables, and it explains how to search for information in dictionary tables.

Organization of this section

• B.1 Dictionary table overview

• B.2 Content of SQL_TABLES

• B.3 Content of SQL_COLUMNS

• B.4 Content of SQL_DIV_TABLE

• B.5 Content of SQL_INDEXES

• B.6 Content of SQL_DIV_INDEX

• B.7 Content of SQL_DBAREAS

• B.8 Content of SQL_SCHEMATA

• B.9 Content of SQL_VIEWS

• B.10 Content of SQL_VIEW_TABLE_USAGE

• B.11 Content of SQL_DEFINE_SOURCE

• B.12 Content of SQL_DEFINE_ENVIRONMENT

• B.13 Content of SQL_USERS

• B.14 Content of SQL_TABLE_CONSTRAINTS

• B.15 Content of SQL_INDEX_COLINF

• B.16 Content of SQL_KEY_COLUMN_USAGE

• B.17 Content of SQL_REFERENTIAL_CONSTRAINTS

• B.18 Content of SQL_TABLE_PRIVILEGES

• B.19 Content of SQL_AUDITS

• B.20 Base tables that are reserved when dictionary tables are referenced

• B.21 B-tree indexes of dictionary tables (base tables)

• B.22 Searching a dictionary table

To Page Top