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 privilegeUSAGE
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.
Syntax
drop_script::=
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.