SQL/MX 2.x Reference Manual (H06.04+)

Metadata Tables
HP NonStop SQL/MX Reference Manual—540440-003
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*:
TBL_PRIVILEGES Table on
page 10-24
Grant information for a table in the catalog
TEXT Table
on page 10-25 Text associated with objects
TRIGGERS Table
on
page 10-25
Information about triggers
TRIGGERS_CAT_USAGE
Table on page 10-26
How triggers use objects in other catalogs
TRIGGER_USED Table
on
page 10-27
Describes how triggers use objects
VWS Table
on page 10-28 Views in the catalog
VW_COL_TBLS Table
on
page 10-28
Base tables referenced by columns of a view
VW_COL_TBL_COLS Table
on
page 10-29
Base table columns used in views
VW_COL_USAGE Table
on
page 10-29
Columns used in views
VW_TBL_USAGE Table
on
page 10-29
Tables referenced by views
System Defaults Table
on
page 10-30
Default settings for system options for SQL queries and
SQLCI commands run through MXCI or through an
application.
*In addition, UMD tables exist here.