DROP SCRIPT
Purpose
Use this statement to drop a script (UDF, scripting program, or adapter script).
Prerequisite
You need to have the system privilege DROP ANY SCRIPT , or the current user or one of their roles is the owner of the script (the whole schema).
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.