SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

Metadata Tables
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-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-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-14
Columns referenced in search conditions of check
constraints
CK_TBL_USAGE Table
on
page 10-15
Tables referenced in search conditions of check
constraints
2
COLS Table on page 10-15 Columns in tables and views
3
COL_PRIVILEGES Table on
page 10-20
Grant information for columns
4
DDL_LOCKS Table on
page 10-21
Lock information for controlling concurrent DDL
operations on an object
5
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
6
OBJECTS Table on
page 10-23
Tables, views, indexes, and constraints
7
PARTITIONS Table on
page 10-24
Partitions in the catalog
8
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
9
SEQUENCE_GENERATORS
Table on page 10-28
Contains the sequence generator attributes.
SG_USAGE Table
on
page 10-28
Represents the usage of Sequence Generator objects by
other objects
TBL_CONSTRAINTS Table
on
page 10-29
Constraints on a table.
10
TBL_PRIVILEGES Table on
page 10-30
Grant information for a table in the catalog
TEXT Table
on page 10-31 Text associated with objects