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

Contents
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
xxix
10. Metadata Tables
UPSHIFT Function 9-202
Examples of UPSHIFT 9-202
USER Function 9-203
Examples of USER 9-203
VERSION_INFO Function 9-204
Example of VERSION_INFO 9-206
VARIANCE Function 9-207
Considerations for VARIANCE 9-207
Examples of VARIANCE 9-210
WEEK Function 9-212
Examples of WEEK 9-212
YEAR Function 9-213
Examples of YEAR 9-213
10. Metadata Tables
SQL/MX Metadata Catalogs 10-2
SQL/MX Metadata Schemas and Tables 10-3
System Schema Tables: Schema SYSTEM_SCHEMA 10-3
Definition Schema Tables: Schema
DEFINITION_SCHEMA_VERSION_vernum 10-3
System Defaults Tables (User Metadata Tables): Schema
SYSTEM_DEFAULTS_SCHEMA 10-5
MXCS Metadata Tables: Schema MXCS_SCHEMA 10-5
Histogram Tables 10-6
VALIDATEROUTINE: Schema SYSTEM_SQLJ_SCHEMA 10-6
Security Schema Tables: Schema SYSTEM_SECURITY_SCHEMA 10-7
System Schema Tables 10-8
ALL_UIDS Table
10-8
CATSYS Table 10-9
CAT_REFERENCES Table 10-9
SCHEMATA Table
10-10
SCHEMA_REPLICAS Table
10-11
System Security Schema Tables 10-12
MGM_PRIVILEGES
10-12
PRIVILEGED_USERS TABLE
10-12
Definition Schema Tables
10-13
ACCESS_PATHS Table
10-13
ACCESS_PATH_COLS Table 10-15
CK_COL_USAGE Table
10-15
CK_TBL_USAGE Table 10-16