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

Metadata Tables
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
10-5
System Defaults Tables (User Metadata Tables):
Schema SYSTEM_DEFAULTS_SCHEMA
System Defaults Tables (User Metadata Tables): Schema
SYSTEM_DEFAULTS_SCHEMA
User metadata that specifies system default settings for options and other attributes
when you execute SQL queries are stored in the SYSTEM_DEFAULTS table in the
schema SYSTEM_DEFAULTS_SCHEMA of catalog NONSTOP_SQLMX_nodename.
The InstallSqlmx script automatically creates the SYSTEM_DEFAULTS table with
the system catalog when you install NonStop SQL/MX. For more information, see the
SQL/MX Installation and Management Guide. Although this user metadata table is in a
schema in the system catalog, it is not a system metadata table but rather a user
metadata table with the security of the user who installs NonStop SQL/MX (normally
the Super ID).
This table lists system defaults tables (user metadata tables) in
NONSTOP_SQLMX_nodename.SYSTEM_DEFAULTS_SCHEMA:
MXCS Metadata Tables: Schema MXCS_SCHEMA
This table lists MXCS tables in the MXCS_SCHEMA:
TRIGGERS_CAT_USAGE
Table on page 10-35
How triggers use objects in other catalogs
TRIGGER_USED Table
on
page 10-35
Describes how triggers use objects
VWS Table
on page 10-36 Views in the catalog
VW_COL_TBL_COLS Table
on
page 10-37
Base table columns used in views
VW_COL_USAGE Table
on
page 10-37
Columns used in views
VW_TBL_USAGE Table
on
page 10-37
Tables referenced by views
System Defaults Table
on
page 10-38
Default settings for system options for SQL queries and
SQLCI commands run through MXCI or through an
application.
ASSOC2DS Table
on
page 10-97
Associates MXCS service to a data source
DATASOURCES Table
on
page 10-98
Data source information
ENVIRONMENTVALUES Table
on page 10-99
Sets, controls and defines environment values