SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

Metadata Tables
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-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).
TRIGGERS Table on
page 10-32
Information about triggers
11
TRIGGERS_CAT_USAGE
Table on page 10-33
How triggers use objects in other catalogs
12
TRIGGER_USED Table on
page 10-33
Describes how triggers use objects
VWS Table
on page 10-34 Views in the catalog
13
VW_COL_TBLS Table on
page 10-35
Base tables referenced by columns of a view
VW_COL_TBL_COLS Table
on
page 10-35
Base table columns used in views
VW_COL_USAGE Table
on
page 10-35
Columns used in views
VW_TBL_USAGE Table
on
page 10-36
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.