SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

SQL/MX Statements

HP NonStop SQL/MX Reference Manual—523725-004

2-129

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;