DROP PROCEDURE (external)
Removes an external procedure from OpenText™ Analytics Database.
Enterprise Mode only
Removes an external procedure from OpenText™ Analytics Database. Only the reference to the procedure inside the database 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);