Seth Woolley's Man Viewer

DROP FUNCTION(7)                 SQL Commands                 DROP FUNCTION(7)



NAME
       DROP FUNCTION - remove a function


SYNOPSIS
       DROP FUNCTION name ( [ type [, ...] ] ) [ CASCADE | RESTRICT ]


DESCRIPTION
       DROP  FUNCTION  removes the definition of an existing function. To exe-
       cute this command the user must be the owner of the function. The argu-
       ment  types  to the function must be specified, since several different
       functions may exist with the same name and different argument lists.

PARAMETERS
       name   The name (optionally schema-qualified) of an existing  function.

       type   The data type of an argument of the function.

       CASCADE
              Automatically  drop objects that depend on the function (such as
              operators or triggers).

       RESTRICT
              Refuse to drop the function if(3,n) any objects depend on it. This is
              the default.

EXAMPLES
       This command removes the square root function:

       DROP FUNCTION sqrt(integer);


COMPATIBILITY
       A DROP FUNCTION statement is defined in(1,8) the SQL standard, but it is not
       compatible with this command.

SEE ALSO
       CREATE  FUNCTION  [create_function(7)],  ALTER  FUNCTION   [alter_func-
       tion(l)]




SQL - Language Statements         2003-11-02                  DROP FUNCTION(7)