Home >> FAQs/Tutorials >> SQL Server FAQ
SQL Server FAQ - "DROP FUNCTION" - Dropping an Existing User Defined Function
(Continued from previous topic...)
How To Drop an Existing User Defined Function?
If you have an existing user defined function that you don't want to use it anymore,
you should delete it from the SQL Server by using the "DROP FUNCTION" statement
as shown in the tutorial example below:
DROP FUNCTION Welcome;
Command(s) completed successfully.
SELECT * FROM sys.objects WHERE type_desc LIKE '%FUNCTION';
name object_id schema_id type type_desc
-------- ----------- ---------- ---- -------------------
Sundays 2117582582 1 FN SQL_SCALAR_FUNCTION
(1 row(s) affected)
User defined function "Welcome" is no longer in the database.
(Continued on next topic...)
- What Are User Defined Functions?
- What Are the Differences between User Defined Functions and Stored Procedures?
- How To Create a Simple User Defined Function?
- How To Use User Defined Functions in Expressions?
- How To List All User Defined Functions in the Current Database?
- How To Drop an Existing User Defined Function?
- How To Generate CREATE FUNCTION Script on an Existing Function?
- How To Get the Definition of a User Defined Function Back?
- How To Modify an Existing User Defined Function?
- How To Create User Defined Functions with Parameters?
- How To Provide Values to User Defined Function Parameters?
- Can You Pass Expressions to Function Parameters?
- How To Provide Default Values to Function Parameters?
- How Many Categories of Functions based Their Return Modes?
- How Many Ways to Create Table-Valued Functions?
- How To Create an Inline Table-Valued Function?
- How To Create an Multi-Statement Table-Valued Function?