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:
where arg‑name optionally qualifies arg‑type. If no arguments are defined for this procedure, specify empty parentheses. |
Privileges
- Superuser or procedure owner
- USAGE privilege on schema, or schema owner
Example
=> DROP PROCEDURE helloplanet(arg1 varchar);