SqlConnection Get list of all tables with type
<p>In my C# code, I create a SqlConnection instance and call the GetSchema method of it as <code>con.GetSchema("Tables");</code>. I need the list of all user tables, system tables, system views, user views separately if possible (with different methods/parameters) or in a single list (provided with a way to filter from it saying using Type info)</p>

<p>Got an answer here <a href="https://stackoverflow.com/questions/24487016/getting-system-tables-and-views-thru-sqlconnection">Getting system tables and views thru SqlConnection</a>, but it is so confusing and I am not sure why both select is exactly same in that SQL.</p>