Where can I find information about stored procedure parameters? In my situation I need to know only the input parameters of given store procedure.
In the sys.objects
there is only common details about the procedure. In sys.sql_modules
I can extract the whole SQL text of a procedure.
As (in SQL Server Management studio) I am able to extract information about the parameters in tabular view using ALT+F1
when selecting the procedure name. I hope there is some place from which I can extract input parameters details in that way.