Dropping External Procedures

Only a superuser can drop an external procedure. To drop the definition for an external procedure from Vertica, use the DROP PROCEDURE statement. Only the reference to the procedure is removed. The external file remains in the <database>/procedures directory on each node in the database.

The definition Vertica uses for a procedure cannot be altered; it can only be dropped.

Example

=> DROP PROCEDURE helloplanet(arg1 varchar);

See Also