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

Querying SQL/MX Metadata

HP NonStop SQL/MX Installation and Management Guide—544536-007

8-35

Displaying Information About SQL/MP Aliases

Topics in this subsection:

•

Displaying All SQL/MP Alias Names in a Schema on page 8-35

•

Displaying All Attributes of an SQL/MP Alias Name on page 8-36

The MP_PARTITIONS table contains the partition names of SQL/MP tables that have

SQL/MP aliases. For detailed information about all metadata tables, see Figure 8-2 on

page 8-7 in this manual or the SQL/MX Reference Manual.

All queries for information about a specific SQL/MP alias must access information from

these tables:

•

CATSYS table

•

SCHEMATA table

•

OBJECTS table

•

MP_PARTITIONS table

Displaying All SQL/MP Alias Names in a Schema

This example displays all SQL/MP aliases in a given schema:

>> select substring(object_name,1,25) as SQLMP_Alias

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 s.schema_name='SALES'

and o.object_type='MP';