Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://docs.snowflake.com/en/sql-reference/sql/drop-function-spcs below:

DROP FUNCTION (Snowpark Container Services)

Removes the specified service function.

See also:

Service functions, CREATE FUNCTION, ALTER FUNCTION, DESC FUNCTION

DROP FUNCTION [ IF EXISTS ] <name> ( [ <arg_data_type> , ... ] )

Copy

name

Specifies the identifier for the service function to drop. If the identifier contains spaces or special characters, the entire string must be enclosed in double quotes. Identifiers enclosed in double quotes are also case sensitive.

arg_data_type [ , ... ]

Specifies the data type of the argument(s), if any, for the service function. The argument types are necessary because service functions support name overloading (that is, two service functions in the same schema can have the same name) and the argument types are used to identify the UDF you wish to drop.

• Dropped functions can’t be recovered; they must be recreated.

• When the IF EXISTS clause is specified and the target object doesn’t exist, the command completes successfully without returning an error.

This demonstrates the DROP FUNCTION command:

DROP FUNCTION my_echo_udf(VARCHAR);

Copy

Example output:

+-----------------------------------+
| status                            |
|-----------------------------------|
| MY_ECHO_UDF successfully dropped. |
+-----------------------------------+

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4