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, 2675🔥, 0💬
Popular Posts:
Can Date and Time Values Be Converted into Integers in SQL Server Transact-SQL? Can date and time va...
How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...
What Is "mysqld" in MySQL? "mysqld" is MySQL server daemon program which runs quietly in background ...
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are list...
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...