title: SQL: Count number of columns in all tables, excluding views
body: <p>I am creating a query that returns the number of columns in each table, but I want to exclude Views.</p>
  
  <p>The following works but returns View results:</p>
  
  <pre><code>SELECT COUNT(*), table_name
  FROM INFORMATION_SCHEMA.COLUMNS
  Group By table_name
  </code></pre>
  
  <p>Any suggestions?</p>
  
  <p>NOTE:  MSSQL 2005+</p>