Get MS Sql Parameters from Stored Procedure

gistfile1.txt

SELECT SCHEMA_NAME(SCHEMA_ID) AS [Schema], 
	SO.name AS [ObjectName],	
	P.parameter_id AS [ParameterID],
	P.name AS [ParameterName],
TYPE_NAME(P.user_type_id) AS [ParameterDataType],
P.max_length AS [ParameterMaxBytes],
P.is_output AS [IsOutPutParameter]
FROM sys.objects AS SO
INNER JOIN sys.parameters AS P 
ON SO.OBJECT_ID = P.OBJECT_ID
WHERE SO.OBJECT_ID IN ( SELECT OBJECT_ID 
FROM sys.objects
--WHERE TYPE IN ('P','FN'))
	where so.name = 'enrolment_delete'
	)
--ORDER BY [Schema], SO.name, P.parameter_id
--GO