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, 1419🔥, 0💬
Popular Posts:
How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...
What Is ISAM in MySQL? ISAM (Indexed Sequential Access Method) was developed by IBM to store and ret...
What Is a Parameter File in Oracle? A parameter file is a file that contains a list of initializatio...
Collections: Interview Questions MySQL Tutorials MySQL Functions Oracle Tutorials SQL Server Tutoria...
How To Create a Table Index in Oracle? If you have a table with a lots of rows, and you know that on...