Dropping external procedures
Only a superuser can drop an external procedure.
Enterprise Mode only
Only a superuser can drop an external procedure. To drop the definition for an external procedure from Vertica, use the DROP PROCEDURE (external) statement. Only the reference to the procedure is removed. The external file remains in the <database>/procedures directory on each node in the database.
Note
The definition Vertica uses for a procedure cannot be altered; it can only be dropped.Example
=> DROP PROCEDURE helloplanet(arg1 varchar);