title: retrieve FoxPro 7.0 database schema
body: <p>I need to obtain a list of tables in a Visual Fox Pro database. (7.0)  This is what I'm doing.... but it's not working or I'm not doing it right...</p>
  
  <pre><code>DataFactory dataFactory = new DataFactory();
  
  dataFactory.CreateOldStarbaseConnection();
  dataFactory.OpenOldStarbaseConnection();
  OleDbConnection oldStarbaseConnection = dataFactory.OldStarbaseConnection;
  
  object[] arrRestrict = new object[] { null, null, "NewStarbase", null };
  
  // Get the tables in the new Database
  DataTable tblDbSchema = newStarbaseConnection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, arrRestrict);
  
  // for each table in the new database
  foreach (DataRow myDataRow in tblDbSchema.Rows)
  {}
  </code></pre>