SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

Metadata Tables
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
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-13
Physical instances (a table, index, or a partition) of data
in the catalog
ACCESS_PATH_COLS Table
on page 10-15
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-16
Tables referenced in search conditions of check
constraints
COLS Table
on page 10-16 Columns in tables and views
COL_PRIVILEGES Table
on
page 10-21
Grant information for columns
DDL_LOCKS Table
on
page 10-22
Lock information for controlling concurrent DDL
operations on an object
DDL_PARTITION_LOCKS
on
page 10-22
DDL locks being held on partitions
KEY_COL_USAGE Table
on
page 10-23
Constraints on key columns
MP_PARTITIONS Table
on
page 10-23
Partition names of SQL/MP tables with SQL/MX aliases
OBJECTS Table
on page 10-24 Tables, views, indexes, and constraints
PARTITIONS Table
on
page 10-25
Partitions in the catalog
REF_CONSTRAINTS Table
on
page 10-26
Referential constraints on tables in the catalog
REPLICAS Table
on page 10-27 Location of replicas in the catalog
RI_UNIQUE_USAGE Table
on
page 10-27
Unique constraints and their referential constraints
ROUTINES Table
on
page 10-28
User-defined stored procedures
SEQUENCE_GENERATORS
Table on page 10-29
Contains the Sequence Generator attributes.
SG_USAGE Table
on
page 10-30
Represents the usage of Sequence Generator objects by
other objects
TBL_CONSTRAINTS Table
on
page 10-31
Constraints on a table
TBL_PRIVILEGES Table
on
page 10-32
Grant information for tables
TEXT Table
on page 10-33 Text associated with objects
TRIGGERS Table
on
page 10-33
Information about triggers