SQL Statements for FoxPro 3.0 Database Containers

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”).