DROP PROCEDURE

Removes an external procedure from Vertica. Only the reference to the procedure is removed. The external file remains in the database/procedures directory of each database node.

Syntax

DROP PROCEDURE [schema.]procedure‑name( [ arg‑list ] )

Parameters

schema

Specifies a schema. If multiple schemas are defined in the database, include the schema name. For example:

myschema.thisDbObject

procedure‑name

Specifies the procedure to drop.

arg‑list

A comma-delimited list of arguments defined for this procedure when it was created, specified as follows:

[arg‑name] arg‑type[,...]

where arg‑name optionally qualifies arg‑type. If no arguments are defined for this procedure, specify empty parentheses.

Privileges

Example

=> DROP PROCEDURE helloplanet(arg1 varchar);

See Also

CREATE PROCEDURE