DB2 Version 9.7 for Linux, UNIX, and Windows

Dropping aliases

When you drop an alias, its description is deleted from the catalog, any packages and cached dynamic queries that reference the alias are invalidated, and all views and triggers dependent on the alias are marked inoperative.

About this task

To drop aliases, from the command line, issue the DROP statement:

   DROP ALIAS EMPLOYEE-ALIAS