SQL/MP Installation and Management Guide

Creating a Database
HP NonStop SQL/MP Installation and Management Guide—523353-004
5-3
Catalog Tables
Figure 5-1 illustrates relations between catalog tables.
Indexes on Catalog Tables
The catalog tables that have indexes, their index names, and the names of indexed
columns are listed in this table. These indexes are required by the system and are
created automatically for the catalog:
USAGES Describes dependencies among SQL objects.
VERSIONS Contains version information about the catalog. This is a backup
copy of the version information in the CATALOGS table of the
system catalog.
VIEWS Describes views defined on base tables.
Figure 5-1. Catalog Structure
Table Name Index Name Index Columns (page 1 of 2)
INDEXES IXINDE01 INDEXNAME
PARTNS IXPART01 PARTITIONNAME
Table Name Table Function (page 2 of 2)
COLUMNS
TABLES VIEWS
BASETABS FILES INDEXES
CONSTRNT PARTNS KEYS
PROGRAMS COMMENTS USAGES TRANSIDS VERSIONS
CPRULES
CPRLSRCE
Legend
One-to-many
One-to-one
VST005.vsd