Supported SQL statements

Devart ODBC Driver for xBase supports Data Definition Language and Data Manipulation Language statements required for most database operations.

Data Definition Language (DDL)

DDL statements define and manage schema objects.

The supported DDL statements include:

• CREATE TABLE [IF NOT EXISTS] <table_name>(<column_definition_list>)
• CREATE TABLE [IF NOT EXISTS] <table_name> AS SELECT <select_expression>
• ALTER TABLE ADD COLUMN <column_definition>
• ALTER TABLE ALTER COLUMN <column_definition>
• ALTER TABLE DROP COLUMN <column_name>
• DROP TABLE [IF EXISTS] <table_name>
• CREATE INDEX <index_name> ON <table_name>(<column_list>)
• DROP INDEX <index_name> ON <table_name>
• PACK [MEMO|DBF] <table_name>
• ZAP <table_name>
• REINDEX <table_name>

Data Manipulation Language (DML)

DML statements access and modify data in existing schema objects.

The supported DML statements include:

• DELETE
• INSERT
• SELECT
• UPDATE