title: SQL Server INFORMATION_SCHEMA contents
body: <p>In most RDBMS, the meta-model is "self contained", which means that I can find out the model of the meta-model by browsing the meta-model itself. This doesn't seem to be the case with SQL Server. What I want to do is this:</p>
  
  <pre><code>SELECT * FROM INFORMATION_SCHEMA.TABLES
  WHERE TABLE_SCHEMA = 'INFORMATION_SCHEMA'
  </code></pre>
  
  <p>That way, I can discover the <code>INFORMATION_SCHEMA</code> schema itself.</p>
  
  <p>Is there any grant/permission/login setting that I have to configure in order to make the <code>INFORMATION_SCHEMA</code> views be "self contained"?</p>