SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

Metadata Tables
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
10-4
Definition Schema Tables: Schema
DEFINITION_SCHEMA_VERSION_vernum
This table lists definition schema tables in schema
DEFINITION_SCHEMA_VERSION_vernum of each catalog:
ACCESS_PATHS Table on
page 10-12
Physical instances (a table, index, or a partition) of data
in the catalog
ACCESS_PATH_COLS Table
on page 10-14
Columns in physical instances of data
CK_COL_USAGE Table
on
page 10-15
Columns referenced in search conditions of check
constraints
CK_TBL_USAGE Table
on
page 10-15
Tables referenced in search conditions of check
constraints
COLS Table
on page 10-15 Columns in tables and views
COL_PRIVILEGES Table
on
page 10-20
Grant information for columns
DDL_LOCKS Table
on
page 10-21
Lock information for controlling concurrent DDL
operations on an object
DDL_PARTITION_LOCKS
on
page 10-21
DDL locks being held on partitions
KEY_COL_USAGE Table
on
page 10-22
Constraints on key columns
MP_PARTITIONS Table
on
page 10-22
Partition names of SQL/MP tables with SQL/MX aliases
OBJECTS Table
on page 10-22 Tables, views, indexes, and constraints
PARTITIONS Table
on
page 10-24
Partitions in the catalog
REF_CONSTRAINTS Table
on
page 10-25
Referential constraints on tables in the catalog
REPLICAS Table
on page 10-26 Location of replicas in the catalog
RI_UNIQUE_USAGE Table
on
page 10-26
Unique constraints and their referential constraints
ROUTINES Table
on
page 10-27
User-defined stored procedures
SEQUENCE_GENERATORS
Table on page 10-28
Contains the Sequence Generator attributes.
SG_USAGE Table
on
page 10-29
Represents the usage of Sequence Generator objects by
other objects
TBL_CONSTRAINTS Table
on
page 10-29
Constraints on a table
TBL_PRIVILEGES Table
on
page 10-30
Grant information for tables
TEXT Table
on page 10-32 Text associated with objects
TRIGGERS Table
on
page 10-32
Information about triggers