Identify input and output parameters in stored procedure

If I have a stored procedure containing input and output parameters, is it possible to access this information some how? What I would like is a list identifying the parameters and whether they are input or output.

Upvotes: 2

Views: 444

Answers (2)

Damien_The_Unbeliever
Damien_The_Unbeliever

Reputation: 239824

sys.parameters is a table containing such information (e.g. the is_output column)

Upvotes: 0

Martin Smith
Martin Smith

Reputation: 454020

SELECT name, 
       is_output
FROM sys.parameters
WHERE object_id=object_id('dbo.YourProc')

Upvotes: 4

Related Questions