SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

Metadata Tables
HP NonStop SQL/MX Reference Manual—523725-004
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
stored in the same subvolume as the system catalog, it is not a system catalog table
but rather a user 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 MXCS_SCHEMA*:
TRIGGER_USED Table on
page 10-26
Describes how triggers use objects
VWS Table
on page 10-27 Views in the catalog
VW_COL_TBLS Table
on
page 10-27
Base tables referenced by columns of a view
VW_COL_TBL_COLS Table
on
page 10-28
Base table columns used in views
VW_COL_USAGE Table
on
page 10-28
Columns used in views
VW_TBL_USAGE Table
on
page 10-28
Tables referenced by views
System Defaults Table
on
page 10-29
Default settings for system options for SQL queries and
SQLCI commands run through MXCI or through an
application.
*In addition, UMD tables exist here.
ASSOC2DS Table on
page 10-77
Associates MXCS service to a data source
DATASOURCES Table
on
page 10-78
Data source information
ENVIRONMENTVALUES Table
on page 10-79
Sets, controls and defines environment values