On this page

    DROP FUNCTION

    Removes a function. Only the owner of a UDF may drop it.

    Syntax
    DROP FUNCTION [ IF EXISTS ] <function_name>
    

    Parameters

    [ IF EXISTS ]

    String

    Optional

    If included in a query, this phrase prevents exceptions from being thrown should the specified function not exist.


    <function_name>

    String

    The name of an existing user-defined function.

    Example

    Remove a function with the name redact_ssn
    DROP FUNCTION redact_ssn