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-29

Displaying All Schemas Visible on a Node

This example selects information from the CATSYS and SCHEMATA tables to display

a list of all the schemas visible on a node:

>>set schema nonstop_sqlmx_<system name>.system_schema;

--- SQL operation complete.

>>select substring(schema_name,1,30) as schema_name, cat_uid, schema_uid from

nonstop_sqlmx_<system name>.system_schema.schemata;

SCHEMA_NAME CAT_UID SCHEMA_UID

------------------------------ -------------------- --------------------

DEFINITION_SCHEMA_VERSION_3100 3675445194283461677 3675445194285370963

U4SCH 3675445194283461677 3675445194291605119

DEFINITION_SCHEMA_VERSION_3100 3677696992630416073 3677696992631854498

U1SCH 3677696992630416073 3677696992638462633

DEFINITION_SCHEMA_VERSION_3100 3679948741094715385 3679948741111466444

SCHU2 3679948741094715385 3679948741117937496

DEFINITION_SCHEMA_VERSION_3100 3679948745044608021 3679948745055452684

SCHU3 3679948745044608021 3679948745062106473

DEFINITION_SCHEMA_VERSION_3100 3682200465783544535 3682200465783559989

MXCS_SCHEMA 3682200465783544535 3682200465791861990

SYSTEM_DEFAULTS_SCHEMA 3682200465783544535 3682200465791849245

SYSTEM_SCHEMA 3682200465783544535 3682200465783621924

SYSTEM_SECURITY_SCHEMA 3682200465783544535 3682200465791550827

SYSTEM_SQLJ_SCHEMA 3682200465783544535 3682200465791895993

DEFINITION_SCHEMA_VERSION_3100 3682200716839720065 3682200716849609564

U8SCH 3682200716839720065 3682200716856171166

--- 16 row(s) selected.