title: Use SqlConnection.GetSchema to get Tables Only (No Views)
body: <p>When I use </p>
  
  <pre><code>SqlConnection.GetSchema("Tables");
  </code></pre>
  
  <p>it returns all the tables AND views for the target database.</p>
  
  <p>Is there any way to just return tables? All the research I have done indicates I am doing this correctly yet it always returns the views like they are tables. I have dug down into the DataTable in debug and I can't even find a difference. The data types are reported the same... As far as I can tell, it can't differentiate between a view and a table. (It does make sense in a way since a view for all intents and purposes IS a table.)</p>
  
  <p>I am using the Northwind database for testing.</p>
  
  <p>I am writing the application in C#.</p>
  
  <p>Here is the code that I am running to get the schema info. Pretty simple.</p>
  
  <pre><code>SQLCon.Open();
  DataTable tables = SQLCon.GetSchema("Tables");
  SQLCon.Close();
  </code></pre>
  
  <p>I would very much like to use the getschema method and not have to query the database in another fashion... if at all possible.</p>