SQL Server - "DROP FUNCTION" - Dropping an Existing User Defined Function in SQL Server

"DROP FUNCTION" - Dropping an Existing User Defined Function in SQL Server

Q

How To Drop an Existing User Defined Function in SQL Server Transact-SQL?

✍: FYIcenter.com

A

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.

⇒Using User Defined Functions in SQL Server Transact-SQL

⇒⇒SQL Server Transact-SQL Tutorials

2016-12-24, 476👍, 0💬

sys.sql_modules - Getting User Defined Function Definitions Back in SQL Server
How To Get the Definition of a User Defined Function Back in SQL Server Transact-SQL? If you want get the definition of an existing user defined function back from the SQL Server, you can use the system view called sys.sql_modules, which stores definitions of functions, stored procedures, and views.... 2016-12-18, 675👍, 0💬

Generating CREATE FUNCTION Scripts on Existing Functions in SQL Server
How To Generate CREATE FUNCTION Script on an Existing Function in SQL Server Transact-SQL? If you want to know how an existing user defined function was created, you can use SQL Server Management Studio to automatically generate a "CREATE FUNCTION" script The following tutorial shows you how to do t... 2016-12-18, 515👍, 0💬

"DROP FUNCTION" - Dropping an Existing User Defined Function in SQL Server
How To Drop an Existing User Defined Function in SQL Server Transact-SQL? 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... 2016-12-24, 477👍, 0💬

Using User Defined Functions in Expressions in SQL Server
How To Use User Defined Functions in Expressions in SQL Server Transact-SQL? An user defined function must return a value, which can be used in any expression as long as the return value data type matches the expression. To execute a user defined function and use its return value in an expression, y... 2016-12-24, 396👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.