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 is the owner of the script (that is the whole schema).

Syntax

drop_script::=

Drop Script Statement

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;