title: What is the difference between SPECIFIC_SCHEMA and ROUTINE_SCHEMA in INFORMATION_SCHEMA.ROUTINES?
body: <p><code>INFORMATION_SCHEMA.ROUTINES</code> contains these two columns:</p>
  
  <pre><code>SPECIFIC_SCHEMA: Specific name of the schema.
  ROUTINE_SCHEMA: Name of the schema that contains this function.
  </code></pre>
  
  <p><a href="http://technet.microsoft.com/en-us/library/ms188757.aspx" rel="nofollow noreferrer">technet doc</a></p>
  
  <p>For the <code>SPECIFIC_</code> and <code>ROUTINE_</code> versions of <code>CATALOG</code> and <code>NAME</code> are defined to be equivalent (-Specific name of the catalog. This name is the same as <code>ROUTINE_CATALOG</code>.-), but this verbiage is omitted for SCHEMA-  </p>
  
  <p>What is the difference between <code>SPECIFIC_SCHEMA</code> and <code>ROUTINE_SCHEMA</code>?</p>
  
  <p>[Edit: Apparently 3+ years later this is being flagged as a duplicate so I have to clarify. The suggested duplicate is about different fields, so no I do not beleive it is a duplicate.]</p>