Get List of all User Defined Functions

We can use sys.objects(system view) to get the information about user defined functions. Below query return the name of all user defined function along with type.
 
Query
 
SELECT name AS Function_Name, type_desc as Type_
FROM sys.objects
WHERE type_desc LIKE '%FUNCTION%';
GO
 
Example
 
 
Next Recommended Reading User-Defined Functions in SQL Server

Pankaj Kumar Choudhary

Pankaj Kumar Choudhary loves the Microsoft and Database technologies. He has worked experience on several database technology like SQL Server, MySQL, Oracle, MongoDB, PostgreSQL . He has knowledge of several technology ... Read more

https://www.c-sharpcorner.com/members/pankaj-kumar-choudhary
View All Comments