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-31
Displaying All Tables in a Catalog
Displaying All Tables in a Catalog
This example displays all base table objects in the catalog SAMDBCAT:
>> set schema samdbcat.definition_schema_version_1200;
--- SQL operation complete.
>> select substring (object_name, 1, 25) as table_name,
substring(schema_name, 1, 30) as schema_name
from nonstop_sqlmx_figaro.system_schema.catsys c,
nonstop_sqlmx_figaro.system_schema.schemata s,
objects o
where c.cat_uid = s.cat_uid
and c.cat_name = 'SAMDBCAT'
and s.schema_uid = o.schema_uid
and o.object_type = 'BT'
order by schema_name, table_name
for read uncommitted access;
TABLE_NAME SCHEMA_NAME
------------------------- ------------------------------
ACCESS_PATHS DEFINITION_SCHEMA_VERSION_1200
ACCESS_PATH_COLS DEFINITION_SCHEMA_VERSION_1200
CK_COL_USAGE DEFINITION_SCHEMA_VERSION_1200
CK_TBL_USAGE DEFINITION_SCHEMA_VERSION_1200
COLS DEFINITION_SCHEMA_VERSION_1200
COL_PRIVILEGES DEFINITION_SCHEMA_VERSION_1200
DDL_LOCKS DEFINITION_SCHEMA_VERSION_1200
DDL_PARTITION_LOCKS DEFINITION_SCHEMA_VERSION_1200
KEY_COL_USAGE DEFINITION_SCHEMA_VERSION_1200
MODULES DEFINITION_SCHEMA_VERSION_1200
MP_PARTITIONS DEFINITION_SCHEMA_VERSION_1200
OBJECTS DEFINITION_SCHEMA_VERSION_1200
PARTITIONS DEFINITION_SCHEMA_VERSION_1200
REF_CONSTRAINTS DEFINITION_SCHEMA_VERSION_1200
REPLICAS DEFINITION_SCHEMA_VERSION_1200
RI_UNIQUE_USAGE DEFINITION_SCHEMA_VERSION_1200
ROUTINES DEFINITION_SCHEMA_VERSION_1200
TBL_CONSTRAINTS DEFINITION_SCHEMA_VERSION_1200
TBL_PRIVILEGES DEFINITION_SCHEMA_VERSION_1200
TEXT DEFINITION_SCHEMA_VERSION_1200
TRIGGERS DEFINITION_SCHEMA_VERSION_1200
TRIGGERS_CAT_USAGE DEFINITION_SCHEMA_VERSION_1200
TRIGGER_USED DEFINITION_SCHEMA_VERSION_1200
VWS DEFINITION_SCHEMA_VERSION_1200
VW_COL_TBLS DEFINITION_SCHEMA_VERSION_1200
VW_COL_TBL_COLS DEFINITION_SCHEMA_VERSION_1200
VW_COL_USAGE DEFINITION_SCHEMA_VERSION_1200
VW_TBL_USAGE DEFINITION_SCHEMA_VERSION_1200
HISTOGRAMS INVENT
HISTOGRAM_INTERVALS INVENT
PARTLOC INVENT
PARTSUPP INVENT
SUPPLIER INVENT