Home SQL Server Commands
 

DROP FUNCTION

Remove a full-text catalog from a database.

Syntax
      DROP FUNCTION [schema.]function  [,...n ] 

Key:
    schema    The schema to which the user-defined function belongs.

    function  Name of the function(s) to remove.

To run this command first remove any CHECK constraints, or DEFAULT constraints that reference the function.

Also an indexed computed column that references the function will prevent dropping the function.

Example

DROP FUNCTION MySchema.fn_myfunction;
GO

Form follows function - Louis H. Sullivan

Related commands:

CREATE FUNCTION
ALTER FUNCTION

Equivalent Oracle commands:

DROP FUNCTION



Back to the Top

Simon Sheppard
SS64.com