To simply delete an alias, use the DELETE ALIAS command, specifying the alias you are deleting.

To delete all the aliases for a catalog, use EXPORT DISCONNECT, to disconnect the catalog. The aliases are deleted when the catalog is disconnected. When you again connect the catalog (using IMPORT CONNECT), the aliases remain deleted.