SQL/MX 2.x Installation and Management Guide (G06.24+, H06.03+)

Querying SQL/MX Metadata
HP NonStop SQL/MX Installation and Management Guide—523723-004
8-6
SQL/MX Metadata Tables
Figure 8-1 on page 8-5 for that schema. User catalogs do not contain the other
metadata schemas shown in Figure 8-1 on page 8-5.
•
There is one set of statistics tables per schema. These are not shown in Figure 8-1
on page 8-5.
Table 8-1 lists the SQL/MX metadata tables located in the system catalog, including the
clustering keys for each table. Some of the metadata tables are placeholders; they are
in the system catalog but are reserved for future use and are not used in the current
release.
Use this table as a reference for the examples later in this section. For detailed
information about each metadata table, see the SQL/MX Reference Manual.
Table 8-1. SQL/MX Metadata Tables (page 1 of 8)
Schema Table Columns (Clustering Keys in Bold)
SYSTEM_
DEFAULTS_
SCHEMA
SYSTEM_DEFAULTS SUBSYSTEM
ATTRIBUTE
ATTR_VALUE
ATTR_COMMENT
SYSTEM_SCHEMA ALL_UIDS OBJECT_UID
SCHEMA_UID
OBJECT_NAME
OBJECT_NAME_SPACE
CATSYS CAT_NAME
CAT_UID
REPLICATION_RULE
LOCAL_SMD_VOLUME
LOCAL_USER_SCHEMA_COUNT
[reserved for future use]
CAT_OWNER
CAT_REFERENCES CAT_UID
NODE_NAME
SMD_VOLUME
REPLICATION_RULE
SCHEMATA CAT_UID
SCHEMA_NAME
SCHEMA_UID
SCHEMA_OWNER
SCHEMA_VERSION
SCHEMA_SUBVOLUME
CURRENT_OPERATION
SOURCE_VERSION
TARGET_VERSION
SCHEMA_REPLICAS SCHEMA_UID
NODE_NAME