All Forums Database
sateeshgbn 2 posts Joined 09/15
03 Feb 2016
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

;

 

 

You must sign in to leave a comment.