SQL-J Language Reference
Page 24 of 121

DROP METHOD ALIAS statement

DROP METHOD ALIAS removes the specified method alias.

Syntax

DROP METHOD ALIAS MethodAlias

Example

DROP METHOD ALIAS ABS

Dependency System

A method alias cannot be dropped if there is an object dependent on it such as a publication, view, constraint, or open statement.

If there is an open cursor or a view that uses the method alias being dropped, the DROP METHOD ALIAS statement generates an error and does not drop the method alias. Dropping a method alias invalidates other (closed) statements that depend on the method alias.