Alter and drop UDAs

After you register a UDA, you can use the ALTER AGGREGATE command to change the aggregate object files, state, return value, or logging level. You cannot change the aggregate name or argument type list; you must drop the existing aggregate and then create an aggregate with the new name, argument type list, or both.

You can remove a UDA by using the DROP AGGREGATE command. The system does not allow you to drop UDAs that are referenced in any views. You must resolve those dependencies before you can drop the UDA, as described in Dependency checks before you drop UDXs.