DROP PROCEDURE (external)
Removes an external procedure from Vertica.
Enterprise Mode only
Removes an external procedure from Vertica. Only the reference to the procedure inside Vertica is removed. The external file remains in the database/procedures directory of each database node.
Syntax
DROP PROCEDURE [ IF EXISTS ] [[database.]schema.]procedure( [ parameter-list ] )
Parameters
IF EXISTS- Specifies not to report an error if the procedure to drop does not exist. Use this clause in SQL scripts to avoid errors on dropping non-existent objects before attempting to create them.
[database.]schemaDatabase and schema. The default schema is
public. If you specify a database, it must be the current database.procedure- Specifies the procedure to drop.
parameter-list- A comma-delimited list of formal parameters defined for this procedure, specified as follows:
[parameter-name]parameter-type[,...]where
parameter-nameoptionally qualifiesparameter-type.
Privileges
Non-superuser:
-
Owner or DROP privilege
-
USAGE privilege on schema
Examples
=> DROP PROCEDURE helloplanet(arg1 varchar);