title: OLEDB: What is the fastest way to get column metadata for a SQL Server CE table, without selecting any rows?
body: <p>I have to use OLE DB with an SQL Server CE. My task is to obtain the metadata on all the columns in a table.</p>
  
  <p>One way to do it is select all the fields of any row and then obtain <code>IColumnInfo</code> from the resulting row set. However, this is done at the cost of selecting a row.</p>
  
  <p>My question - is it the fastest way or is there a better way to get hold on the <code>DBCOLUMNINFO</code> objects for all the columns in a table?</p>