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-41
Displaying Information About SQL/MP Aliases
CUSTLIST N Y Y
ORDREP N N N
Displaying Information About SQL/MP Aliases
Topics in this subsection:

Displaying All SQL/MP Alias Names in a Schema on page 8-41

Displaying All Attributes of an SQL/MP Alias Name on page 8-42
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_<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 s.schema_name='SALES'
and o.object_type='MP';