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