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:

CREATE FUNCTION
ALTER FUNCTION
Equivalent Oracle commands: DROP FUNCTION


© Copyright SS64.com 1999-2014
Some rights reserved