SQL/MX 3.x Reference Manual (H06.22+, J06.11+)
Metadata Tables
HP NonStop SQL/MX Reference Manual—640322-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
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*:
12
TRIGGER_USED Table on
page 10-30
Describes how triggers use objects
VWS Table
on page 10-31 Views in the catalog
13
VW_COL_TBLS Table on
page 10-32
Base tables referenced by columns of a view
VW_COL_TBL_COLS Table
on
page 10-32
Base table columns used in views
VW_COL_USAGE Table
on
page 10-32
Columns used in views
VW_TBL_USAGE Table
on
page 10-33
Tables referenced by views
1. The ACCESS_PATHS table is updated in SQL/MX R 3.0.
2. The COLS table is updated in SQL/MX R 3.0.
3. The COL_PRIVILEGES table is updated in SQL/MX R 3.0.
4. The DDL_LOCKS table is updated in SQL/MX R 3.0.
5. The DDL_PARTITION_LOCKS table is present in schema version 1200 only.
6. The OBJECTS table is updated in SQL/MX R 3.0.
7. The PARTITIONS table is updated in SQL/MX R 3.0.
8. The REF_CONSTRAINTS table is updated in SQL/MX R 3.0.
9. The TBL_CONSTRAINTS table is updated in SQL/MX R 3.0.
10. The TBL_PRIVILEGES table is updated in SQL/MX R 3.0.
11. The TRIGGERS_CAT_USAGE is updated in SQL/MX R 3.0.
12. The TRIGGER_USED is updated in SQL/MX R 3.0.
13. The VW_COL_TBLS table is present in schema version 1200 only.
System Defaults Table on
page 10-34
Default settings for system options for SQL queries and
SQLCI commands run through MXCI or through an
application.
*In addition, UMD tables exist here.