title: How to obtain a view's structure/query using OleDb?
body: <p>I have an ASP.Net application that reads data from an Access 2010 database file (.mdb).</p>
  <p>I can easily list all tables and views in the database like this:</p>
  <pre><code>string sql = &quot;select name from msysobjects where type in (1,5)&quot;;
  OleDbCommand cmd = new OleDbCommand(sql,con);
  OleDbDataAdapter da = new OleDbDataAdapter(cmd);
  da.Fill(dataTable);   // now dataTable contains all ojbects' names I have created in access
  </code></pre>
  <p>What I would like to inquire about is the structure of the tables/views without relying on Access. I.E, using external OleDb commands.</p>
  <p>In Oracle, I could do so by running the command</p>
  <pre><code>describe table_name;
  describe view_name;
  describe procedure_name;
  </code></pre>
  <p>but how can it be done in MS Access?</p>