You can store Foxpro tables together inside a single Foxpro database file (.dbc), or you can store each table in its own separate .dbf file. When using .dbf files, be sure the file name is filled into the location string. Otherwise the directory where Sybase IQ was started will be used.
CREATE TABLE fox1 (a int, b char(20)) AT 'foxpro;d:\pcdb;;fox1'
This statement creates a file named d:\pcdb\fox1.dbf when you choose the “free table directory” option in the odbc driver manager.
