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

Displaying Information About SQL/MP Aliases

Topics in this subsection:

•

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

•

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

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 Table 8-1 on

page 8-6 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';