DROP FUNCTION_SOURCE

Syntax

DROP FUNCTION_SOURCE function_source_name;

Description

Drops a Function Source. It can only be executed by the Function Source owner.

DROP FUNCTION_SOURCE cannot be undone. Use it with care!

Parameters

function_source_name

The name of the Function Source to drop. For case-sensitive names, the name must be wrapped in double quotes, otherwise, the lowercased name will be used.

Example

Drop a Function Source

Assume a Function Source, named mysrc, is created using the CREATE FUNCTION SOURCE statement and is now available:

db1.public/my_store# CREATE FUNCTION_SOURCE "MySrc" WITH ( 'file' = '/path/to/fnsrc.jar', 'description' = 'my functions' );
db1.public/my_store# LIST FUNCTION_SOURCES;
  Name  | Description |  Owner   |      Created at      |      Updated at       
--------+-------------+----------+----------------------+-----------------------
  mysrc | my functions  | sysadmin | 2023-02-22T21:31:55Z | 2023-02-22T21:31:55Z  

This Function Source can be dropped with the below statement:

db1.public/my_store# DROP FUNCTION_SOURCE "MySrc";
db1.public/my_store# LIST FUNCTION_SOURCES;
  Name | Description | Owner | Created at | Updated at  
-------+-------------+-------+------------+-------------