SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

Metadata Tables
HP NonStop SQL/MX Reference Manual—523725-004
10-4
Definition Schema Tables: Schema
DEFINITION_SCHEMA_VERSION_vernum
Within system metadata tables, each object or partition is identified by a unique ID
(UID). A UID is a 64-bit number, unique within the node, generated and assigned to the
object or partition at the time it is created.
This table lists definition schema tables in schema
DEFINITION_SCHEMA_VERSION_vernum of each catalog:
ACCESS_PATHS Table on
page 10-10
Physical instances (a table, index, or a partition) of data
in the catalog
ACCESS_PATH_COLS Table
on page 10-11
Columns in physical instances of data
CK_COL_USAGE Table
on
page 10-12
Columns referenced in search conditions of check
constraints
CK_TBL_USAGE Table
on
page 10-12
Tables referenced in search conditions of check
constraints
COLS Table
on page 10-12 Columns in tables and views
COL_PRIVILEGES Table
on
page 10-16
Grant information for columns
DDL_LOCKS Table
on
page 10-17
Lock information for controlling concurrent DDL
operations on an object
KEY_COL_USAGE Table
on
page 10-17
Constraints on key columns
MP_PARTITIONS Table
on
page 10-18
Partition names of SQL/MP tables with SQL/MX aliases
OBJECTS Table
on page 10-18 Tables, views, indexes, and constraints
PARTITIONS Table
on
page 10-19
Partitions in the catalog
REF_CONSTRAINTS Table
on
page 10-20
Referential constraints on tables in the catalog
REPLICAS Table
on page 10-21 Location of replicas in the catalog
RI_UNIQUE_USAGE Table
on
page 10-21
Unique constraints and their referential constraints
ROUTINES Table
on
page 10-22
User-defined stored procedures
TBL_CONSTRAINTS Table
on
page 10-23
Constraints on a table
TBL_PRIVILEGES Table
on
page 10-23
Grant information for a table in the catalog
TEXT Table
on page 10-24 Text associated with objects
TRIGGERS Table
on
page 10-24
Information about triggers
TRIGGERS_CAT_USAGE
Table on page 10-25
How triggers use objects in other catalogs