I need a dual database in my application: SQL and Foxpro Tables (FOX2X not DBC).

I need to create the tables for both programmatically.

Working with Microsoft SQL and SQLCommand() it’s very easy to create a new database and the tables. This is working.

I need the equivalent with OleDbCommand(), or am I just creating tables with SELECT statements (i.e. WHERE False – create table without records) and that’s all there is to it? How do I create indexes (CDXs) on these tables that will allow subsequent SQL commands to use Rushmore?

The documentation for Microsoft’s Transact-SQL is very good, is there similar documentation for Foxpro table usage through OleDbCommand()?

Thanks in advance.