SQL/MX 3.1 Installation and Management Guide (H06.23+, J06.12+)

Querying SQL/MX Metadata
HP NonStop SQL/MX Release 3.1 Installation and Management Guide—663852-001
8-34
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_<schema
version>;
--- SQL operation complete.
>> select substring (object_name, 1, 25) as table_name,
substring(schema_name, 1, 30) as schema_name
from nonstop_sqlmx_<system name>.system_schema.catsys c,
nonstop_sqlmx_<system name>.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_3000
ACCESS_PATH_COLS DEFINITION_SCHEMA_VERSION_3000
CK_COL_USAGE DEFINITION_SCHEMA_VERSION_3000
CK_TBL_USAGE DEFINITION_SCHEMA_VERSION_3000
COLS DEFINITION_SCHEMA_VERSION_3000
COL_PRIVILEGES DEFINITION_SCHEMA_VERSION_3000
DDL_LOCKS DEFINITION_SCHEMA_VERSION_3000
DDL_PARTITION_LOCKS DEFINITION_SCHEMA_VERSION_3000
EXCEPTION_USAGE DEFINITION_SCHEMA_VERSION_3000
KEY_COL_USAGE DEFINITION_SCHEMA_VERSION_3000
MP_PARTITIONS DEFINITION_SCHEMA_VERSION_3000
MVGROUPS DEFINITION_SCHEMA_VERSION_3000
MVS DEFINITION_SCHEMA_VERSION_3000
MVS_COLS DEFINITION_SCHEMA_VERSION_3000
MVS_JOIN_COLS DEFINITION_SCHEMA_VERSION_3000
MVS_TABLE_INFO DEFINITION_SCHEMA_VERSION_3000
MVS_USED DEFINITION_SCHEMA_VERSION_3000
OBJECTS DEFINITION_SCHEMA_VERSION_3000
PARTITIONS DEFINITION_SCHEMA_VERSION_3000
REF_CONSTRAINTS DEFINITION_SCHEMA_VERSION_3000
REPLICAS DEFINITION_SCHEMA_VERSION_3000
RI_UNIQUE_USAGE DEFINITION_SCHEMA_VERSION_3000
ROUTINES DEFINITION_SCHEMA_VERSION_3000
SCH_PRIVILEGES DEFINITION_SCHEMA_VERSION_3000
SEQUENCE_GENERATORS DEFINITION_SCHEMA_VERSION_3000
SG_USAGE DEFINITION_SCHEMA_VERSION_3000
SYNONYM_USAGE DEFINITION_SCHEMA_VERSION_3000
TBL_CONSTRAINTS DEFINITION_SCHEMA_VERSION_3000
TBL_PRIVILEGES DEFINITION_SCHEMA_VERSION_3000
TEXT DEFINITION_SCHEMA_VERSION_3000
TRIGGERS DEFINITION_SCHEMA_VERSION_3000
TRIGGERS_CAT_USAGE DEFINITION_SCHEMA_VERSION_3000