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, 2808🔥, 0💬
Popular Posts:
What Is SQL*Plus in Oracle? SQL*Plus is an interactive and batch query tool that is installed with e...
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...
How To Create a Dynamic Cursor with the DYNAMIC Option in SQL Server Transact-SQL? If the underlying...
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...
How To Insert New Line Characters into Strings in SQL Server Transact-SQL? If you want to break a st...