SQL-J Language Reference
Page 22 of 121

DROP CLASS ALIAS statement

DROP CLASS ALIAS removes the specified class alias. You cannot drop a built-in class alias.

Syntax

DROP CLASS ALIAS ClassAlias

Example

DROP CLASS ALIAS Person

Dependency System

A class alias cannot be dropped if there is an object dependent on it such as a publication, view, constraint, or open statement. Tables are not dependent upon class aliases; a class alias is simply a syntactic shortcut for providing the type definition for columns and parameters.

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