SQL/MX 2.x Reference Manual (H06.04+)

Metadata Tables
HP NonStop SQL/MX Reference Manual—540440-003
10-4
Definition Schema Tables: Schema
DEFINITION_SCHEMA_VERSION_vernum
Definition Schema Tables: Schema
DEFINITION_SCHEMA_VERSION_vernum
Additional system metadata for each object is stored in schema
DEFINITION_SCHEMA_VERSION_vernum in the catalog that contains the object.
NonStop SQL/MX automatically creates this schema and all its tables when you
execute the first CREATE SCHEMA statement for that catalog.
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-11
Physical instances (a table, index, or a partition) of data
in the catalog
ACCESS_PATH_COLS Table
on page 10-12
Columns in physical instances of data
CK_COL_USAGE Table
on
page 10-13
Columns referenced in search conditions of check
constraints
CK_TBL_USAGE Table
on
page 10-13
Tables referenced in search conditions of check
constraints
COLS Table
on page 10-13 Columns in tables and views
COL_PRIVILEGES Table
on
page 10-17
Grant information for columns
DDL_LOCKS Table
on
page 10-18
Lock information for controlling concurrent DDL
operations on an object
KEY_COL_USAGE Table
on
page 10-18
Constraints on key columns
MP_PARTITIONS Table
on
page 10-19
Partition names of SQL/MP tables with SQL/MX aliases
OBJECTS Table
on page 10-19 Tables, views, indexes, and constraints
PARTITIONS Table
on
page 10-20
Partitions in the catalog
REF_CONSTRAINTS Table
on
page 10-21
Referential constraints on tables in the catalog
REPLICAS Table
on page 10-22 Location of replicas in the catalog
RI_UNIQUE_USAGE Table
on
page 10-22
Unique constraints and their referential constraints
ROUTINES Table
on
page 10-23
User-defined stored procedures
TBL_CONSTRAINTS Table
on
page 10-24
Constraints on a table