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::=

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;