Seth Woolley's Man Viewer

ALTER FUNCTION(7)                SQL Commands                ALTER FUNCTION(7)



NAME
       ALTER FUNCTION - change the definition of a function


SYNOPSIS
       ALTER FUNCTION name ( [ type [, ...] ] ) RENAME TO newname


DESCRIPTION
       ALTER FUNCTION changes the definition of a function. The only function-
       ality is to rename(1,2,n) the function.

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

       type   The data type of an argument of the function.

       newname
              The new name of the function.

EXAMPLES
       To rename(1,2,n) the function sqrt for type integer to square_root:

       ALTER FUNCTION sqrt(integer) RENAME TO square_root;


COMPATIBILITY
       There  is  an ALTER FUNCTION statement in(1,8) the SQL standard, but it does
       not provide the option to rename(1,2,n) the function.

SEE ALSO
       CREATE FUNCTION [create_function(7)], DROP FUNCTION [drop_function(l)]




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