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 [ IF EXISTS ] [[database.]schema.]procedure( [ arg‑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.]schema

Specifies a schema, by default public. If schema is any schema other than public, you must supply the schema name. For example:

myschema.thisDbObject

If you specify a database, it must be the current database.

procedure

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

Non-superuser:

Example

=> DROP PROCEDURE helloplanet(arg1 varchar);

See Also

CREATE PROCEDURE