DROP SCRIPT

Purpose

Use this statement to drop a script (UDF, scripting program, or adapter script).

Prerequisites

• You need either the system privilege USE ANY SCHEMA or the object privilege USAGE on the target schema, or the schema must be owned by you or one of your assigned roles.

• You need the system privilege DROP ANY SCRIPT, or the script and its containing schema must be owned by your or one of your assigned roles.

Usage Notes

• If the optional clause IF EXISTS is specified, then the statement does not throw an exception if the script does not exist.
• In case of an adapter script still referenced by a virtual schema, a script cannot be dropped and an exception is thrown.

Example

DROP SCRIPT my_script;