Statements

QDB recognizes more than 20 types of SQL statements that create, modify, and delete tables, indexes, and triggers, and perform specialized tasks such as database cleanup.

The statements described in this chapter are:

• ALTER TABLE
• ANALYZE
• ATTACH DATABASE
• CREATE INDEX
• CREATE TABLE
• CREATE TRIGGER
• CREATE VIEW
• DELETE
• DETACH DATABASE
• DROP INDEX
• DROP TABLE
• DROP TRIGGER
• DROP VIEW
• EXPLAIN
• INSERT
• ON CONFLICT
• PRAGMA
• REINDEX
• REPLACE
• SELECT
• TRANSACTION
• UPDATE
• VACUUM