Few days ago, I wrote about SQL SERVER – Find All The User Defined Functions (UDF) in a Database. Regular reader of this blog Madhivanan has suggested following alternate method to do the same task of finding all the user defined functions in database. USE AdventureWorks GO SELECT specific_name,specific_schema FROM…

Following script is very simple script which returns all the User Defined Functions for particular database. USE AdventureWorks; GO SELECT name AS function_name ,SCHEMA_NAME(schema_id) AS schema_name ,type_desc FROM sys.objects WHERE type_desc LIKE '%FUNCTION%'; GO Reference : Pinal Dave (https://darkslategrey-bat-805937.hostingersite.com)