Help with stored procedure metadat

Database

Help with stored procedure metadat

I want to extract meta data for stored procedure from dbc tables something like this.

select

a.name AS [ParameterName],

a.parameter_id AS [ParameterID],

TYPE_NAME(a.user_type_id) AS [ParameterDataType],

a.max_length AS [ParameterMaxBytes],

a.is_output AS [IsOutPutParameter]

from

sys.parameters a

;