SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

SQL/MX Statements

HP NonStop SQL/MX Reference Manual—640322-001

2-133

Examples of DROP SQLMP ALIAS

•

Suppose that you have created an SQL/MP table by using this SQL/MP CREATE

TABLE statement:

CREATE TABLE $myvol.mysubvol.mytable

( num NUMERIC (4) UNSIGNED NOT NULL

,name VARCHAR (20)

,PRIMARY KEY (num) );

This statement creates a mapping in the system metadata table:

CREATE SQLMP ALIAS mycatalog.myschema.mytable

$myvol.mysubvol.mytable;

This statement drops the mapping in the system metadata table:

DROP SQLMP ALIAS mycatalog.myschema.mytable;