Collections:
sys.objects - Listing All User Defined Functions in SQL Server
How To List All User Defined Functions in the Current Database in SQL Server Transact-SQL?
✍: FYIcenter.com
If you want to see a list of all user defined functions in your current database, you can use the system view, sys.objects as shown in this tutorial exercise:
USE FyiCenterData; GO -- Number of Sundays in a given year CREATE FUNCTION Sundays() RETURNS INT AS BEGIN DECLARE @date DATETIME; DECLARE @count INT; SET @date = '2017-12-31'; SET @count = 0; WHILE DATEPART(YEAR, @date) <= 2018 BEGIN SET @date = DATEADD(DAY, 1, @date); IF DATENAME(WEEKDAY, @date) = 'Sunday' SET @count = @count + 1; END; RETURN @count; END; SELECT * FROM sys.objects WHERE type_desc LIKE '%FUNCTION'; GO name object_id schema_id type type_desc -------- ----------- ---------- ---- ------------------- Welcome 2085582468 1 FN SQL_SCALAR_FUNCTION Sundays 2117582582 1 FN SQL_SCALAR_FUNCTION (2 row(s) affected)
sys.objects contains all types of objects in the current database. You need select only the FUNCTION object type.
⇒ "DROP FUNCTION" - Dropping an Existing User Defined Function in SQL Server
⇐ Using User Defined Functions in Expressions in SQL Server
2016-12-24, 2663🔥, 0💬
Popular Posts:
How To Get the Definition of a Stored Procedure Back in SQL Server Transact-SQL? If you want get the...
How To Update Multiple Rows with One UPDATE Statement in SQL Server? If the WHERE clause in an UPDAT...
Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...
How to continue to the next iteration of a WHILE loop in SQL Server Transact-SQL? How to use CONTINU...