Collections:
"DROP FUNCTION" - Dropping an Existing User Defined Function in SQL Server
How To Drop an Existing User Defined Function in SQL Server Transact-SQL?
✍: FYIcenter.com
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:
USE FyiCenterData; GO DROP FUNCTION Welcome; GO Command(s) completed successfully. SELECT * FROM sys.objects WHERE type_desc LIKE '%FUNCTION'; GO 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.
2016-12-24, 694👍, 0💬
Popular Posts:
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...
How to download and install SQL Server 2005 Sample Scripts in SQL Server? If you want to learn from ...
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...
How To Concatenate Two Text Values in Oracle? There are two ways to concatenate two text values toge...
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...