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.
⇒ Generating CREATE FUNCTION Scripts on Existing Functions in SQL Server
⇐ sys.objects - Listing All User Defined Functions in SQL Server
2016-12-24, 1360🔥, 0💬
Popular Posts:
What is sqlservr.exe - Process - SQL Server (SQLEX?PRESS) in SQL Server? Process sqlservr.exe is the...
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...
How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...
How To Get the Definition of a User Defined Function Back in SQL Server Transact-SQL? If you want ge...
How To Convert Binary Strings into Integers in SQL Server Transact-SQL? Binary strings and integers ...