user defined function definition for sql server

TSqlUserDefinedFunctionDefinitions.sql

USE DER_CommProg;
GO

CREATE TABLE #functionInfo
(
  ID BIGINT NOT NULL
	,Name VARCHAR(200) NULL
	,[SchemaName] VARCHAR(200) NULL
	,[Description] VARCHAR(200) NULL
	,[Definition] VARCHAR(MAX) NULL
)
INSERT INTO #functionInfo
SELECT 
object_id
,name AS function_name
,SCHEMA_NAME(schema_id) AS schema_name
,type_desc
,OBJECT_DEFINITION(object_id)
FROM sys.objects
WHERE type_desc LIKE '%FUNCTION%'
ORDER BY 1,2,3,4;
GO

SELECT Definition FROM #functionInfo ORDER BY Name

DROP TABLE #functionInfo