SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

Metadata Tables
HP NonStop SQL/MX Reference Manual—640322-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:
1
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-13
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
2
COLS Table on page 10-14 Columns in tables and views
3
COL_PRIVILEGES Table on
page 10-18
Grant information for columns
4
DDL_LOCKS Table on
page 10-19
Lock information for controlling concurrent DDL
operations on an object
5
DDL_PARTITION_LOCKS on
page 10-19
DDL locks being held on partitions
KEY_COL_USAGE Table
on
page 10-20
Constraints on key columns
MP_PARTITIONS Table
on
page 10-20
Partition names of SQL/MP tables with SQL/MX aliases
6
OBJECTS Table on
page 10-21
Tables, views, indexes, and constraints
7
PARTITIONS Table on
page 10-22
Partitions in the catalog
8
REF_CONSTRAINTS Table on
page 10-23
Referential constraints on tables in the catalog
REPLICAS Table
on page 10-24 Location of replicas in the catalog
RI_UNIQUE_USAGE Table
on
page 10-24
Unique constraints and their referential constraints
ROUTINES Table
on
page 10-25
User-defined stored procedures
9
TBL_CONSTRAINTS Table on
page 10-26
Constraints on a table
10
TBL_PRIVILEGES Table on
page 10-27
Grant information for a table in the catalog
TEXT Table
on page 10-28 Text associated with objects
TRIGGERS Table
on
page 10-28
Information about triggers
11
TRIGGERS_CAT_USAGE
Table on page 10-30
How triggers use objects in other catalogs