The FoxPro DBC driver supports four additional SQL statements:

  • Create Database
  • Add Table
  • Remove Table
  • Use

To create a new FoxPro 3.0 database container, use:

CREATE DATABASE database_name

To add an existing table to the database container, use:

ADD TABLE table_name

To remove a table from the database container (not delete the table, but unlink it from the database container), use:

REMOVE TABLE table_name

To set the current database container to an existing database container, use:

USE database_name

To add or delete columns from a table in a database container, use the Alter Table statement (see Alter Table Statement).