Supported SQL statements

Devart ODBC Driver for SQLite supports a wide range of SQL statements required for most database operations. For the full syntax and a complete list of SQL statements, see the SQLite documentation.

Data Definition Language (DDL) statements

DDL statements define and manage schema objects.

The supported DDL statements include:

• ALTER (all statements beginning with ALTER)
• CREATE (all statements beginning with CREATE)
• DROP (all statements beginning with DROP)

Data Manipulation Language (DML) statements

DML statements access and modify data in existing schema objects.

The supported DML statements include:

• DELETE
• EXPLAIN
• INSERT
• REINDEX
• REPLACE
• SELECT
• UPDATE
• UPSERT

Transaction Control statements

Transaction control statements manage changes made by DML operations.

The supported transaction control statements include:

• BEGIN TRANSACTION
• COMMIT TRANSACTION
• END TRANSACTION
• RELEASE SAVEPOINT
• ROLLBACK TRANSACTION
• SAVEPOINT