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. All views and triggers dependent on the alias are marked inoperative.

Procedure

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

   DROP ALIAS employee-alias