To list all user defined functions in MSSQL you can use the following snippet.
Sample MSSQL
SELECT name AS function_name, SCHEMA_NAME(schema_id) AS SCHEMA_NAME ,type_desc FROM sys.objects WHERE type_desc LIKE '%FUNCTION%' ORDER BY name asc;
One thought on “How to list all user defined functions in MSSQL”
Leave a Reply
You must be logged in to post a comment.
RT @CodeSnippetsNET: How to list all user defined functions in #MSSQL http://t.co/mG7TECgA2A #sql #dotnet