SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
C-9
Operations on Catalog Tables
Operations on Catalog Tables
You create a catalog with CREATE CATALOG. You drop a catalog (after dropping all
user-defined collations, indexes, programs, tables, and views that the catalog
describes) with DROP CATALOG.
You can alter the security of an entire catalog with ALTER CATALOG, or alter the
security of the CATALOGS, PROGRAMS, TRANSIDS, or USAGES catalog tables with
ALTER TABLE.
You can find the version of a catalog with GET VERSION and change the version with
UPGRADE CATALOG or DOWNGRADE CATALOG. (To change the version of the
system catalog, use UPGRADE SYSTEM CATALOG or DOWNGRADE SYSTEM
CATALOG.)
SQL automatically updates the contents of catalog tables for you as you execute other
statements that create, drop, or modify objects described in the catalog. (A few fields
COMMENTS Stores comments on collations, columns, constraints, indexes, tables, and
views; also stores help text for columns
CONSTRNT Describes constraints defined on tables
CPRLSRCE Stores source for collations
CPRULES Describes collations
FILES Describes attributes of files that contain tables and indexes
INDEXES Describes indexes defined on tables
IXINDE01 Unique index on INDEXNAME column of INDEXES table
IXPART01 Nonunique index on PARTITIONNAME column of PARTNS table
IXPROG01 Nonunique index on GROUPID and USERID columns of PROGRAMS table
IXTABL01 Nonunique index on GROUPID and USERID columns of TABLES table
IXUSAG01 Nonunique index on USINGOBJNAME and USINGOBJTYPE columns of
USAGES table
KEYS Describes the key columns of indexes
PARTNS Describes partitions of tables and indexes
PROGRAMS Describes SQL program files
TABLES Describes tables, views, and collations
TRANSIDS Stores TMF transaction IDs for current DDL operations on the catalog
USAGES Describes dependencies among SQL objects
VERSIONS Keeps version information about the catalog
VIEWS Describes the attributes of views
Table C-1. Catalog Tables and Indexes (page 2 of 2)
Table Function