SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Statements

HP NonStop SQL/MX Reference Manual—540440-003

2-125

DROP SQLMP ALIAS Statement

Considerations for DROP SQLMP ALIAS

Examples of DROP SQLMP ALIAS

The DROP SQLMP ALIAS statement is used to drop mappings from ANSI names to

physical names of SQL/MP tables or views.

DROP SQLMP ALIAS is an SQL/MX extension.

catalog.schema.object

is the alias name of an SQL/MP table or view. catalog and schema denote

ANSI-defined catalog and schema, and object is a simple name for the table or

view. If any of the three parts of the name is an SQL/MX reserved word, you must

delimit it by enclosing it in double quotes. For example: mycat.”sql”.myview.

See Catalogs on page 6-2 and Schemas on page 6-101.

Considerations for DROP SQLMP ALIAS

Usage Restrictions

If no alias exists for a given logical name, NonStop SQL/MX returns an error.

Any applications that attempt to use the dropped mapping will get an error because the

specific alias no longer exists.

The DROP SQLMP ALIAS statement does not cause the underlying SQL/MP object to

be dropped. Similarly, dropping an underlying SQL/MP object does not cause any

SQLMP aliases to be dropped. Those aliases remain unchanged and orphaned.

Security of Alias

To drop an alias, you must be the owner of the schema in which the alias resides or be

the super ID.

Comparison with Previous Versions

In SQL/MX releases earlier than SQL/MX Release 2.x, the maximum length of the alias

name was 200 characters. Starting with these releases, the alias name is an ANSI

name.

In product versions prior to SQL/MX Release 2.x, SQLMX allows any user to drop

aliases.

DROP SQLMP ALIAS catalog.schema.object