SQL/MP Installation and Management Guide

Creating a Database
HP NonStop SQL/MP Installation and Management Guide—523353-004
5-2
Catalog Tables
A catalog has two types of components, described in these subsections:
•
Catalog tables
•
Indexes on catalog tables
Catalog Tables
Each SQL/MP catalog table describes either a particular type of object or some aspect
of an object. For instance, the BASETABS catalog table describes base tables.
Each catalog table has a name assigned by the system; for example, BASETABS.
Although the table names are the same in all catalogs, the full name of each catalog
table is unique in the network. For example, the full name of the BASETABS catalog
table in the SUBV1 catalog is \SYS1.$VOL1.SUBV1.BASETABS.
The individual catalog tables that make up a SQL/MP catalog are:
Table Name Table Function (page 1 of 2)
BASETABS Describes base tables (database tables but not views).
CATALOGS Describes all catalogs on the system. This table is the system
directory of catalogs and resides only in the system catalog.
COLUMNS Describes the columns of each table listed in the TABLES catalog
table.
COMMENTS Contains comments on tables, views, indexes, constraints, and
collations; comments on columns described in the catalog; and help
text for columns.
CONSTRNT Describes constraints defined on base tables.
CPRULES Describes collations.
CPRLSRCE Stores source text for character processing rules.
FILES Describes attributes of files that contain tables and indexes.
INDEXES Describes columns of primary keys and indexes.
KEYS Describes the key columns of indexes.
PARTNS Describes partitions of tables and indexes.
PROGRAMS Describes object program files that have been SQL compiled.
TABLES Describes tables and protection and shorthand views.
TRANSIDS Keeps TMF transaction IDs for current DDL operations on the
catalog. This information helps prevent multiple DDL operations
from being executed on the same catalog at the same time within
the same TMF transaction ID