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