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 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]



sys.parameters a




You must sign in to leave a comment.