title: Find which parameters of stored procedures are nullable (optional)
body: <p>I know I can use the following query to find all stored procedures and their parameters :</p>
  
  <pre><code>SELECT 
      r.*, p.*
  FROM
      INFORMATION_SCHEMA.ROUTINES AS r INNER JOIN
      INFORMATION_SCHEMA.PARAMETERS AS p 
      ON r.SPECIFIC_SCHEMA = p.SPECIFIC_SCHEMA AND r.SPECIFIC_NAME = p.SPECIFIC_NAME
  WHERE     (r.ROUTINE_TYPE = N'PROCEDURE')
  </code></pre>
  
  <p>From this I can see (almost) all info about parameters, but I don't know how to find which of them are nullable or have default values.</p>
  
  <p>Is there any way to find this?</p>
  
  <p>Thank you </p>