DROP PROCEDURE (External)
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.]schema
|
Database and schema. The default schema is |
procedure |
Specifies the procedure to drop. |
parameter‑list |
A comma-delimited list of formal parameters defined for this procedure, specified as follows:
where parameter‑name optionally qualifies parameter‑type. |
Privileges
Non-superuser:
- Owner or DROP privilege
- USAGE privilege on schema
Example
=> DROP PROCEDURE helloplanet(arg1 varchar);