SQL Command Reference

This reference describes the SQL command surface verified for RadixDB 1.2 at revision 23bf35df011aae6816d77578be96074b02bc363c. Each command page gives the accepted syntax, result, transaction behavior, errors, privileges and an executable example. The coverage matrix remains the authoritative list of supported, limited and rejected contracts.

Queries and data changes

• SELECT reads and combines rows.
• INSERT adds rows and handles supported conflicts.
• UPDATE changes matching rows.
• DELETE removes matching rows.

Schema and metadata

• CREATE TABLE, ALTER TABLE and DROP TABLE manage tables.
• CREATE INDEX, ALTER INDEX and DROP INDEX manage secondary access structures.
• DESCRIBE and SHOW inspect catalog metadata.

Transaction control

• BEGIN, COMMIT and ROLLBACK delimit explicit transactions.
• SAVEPOINT and RELEASE SAVEPOINT provide partial rollback points.
• SET changes the supported engine default.

Unquoted identifiers are case-insensitive. Brackets in a synopsis mark an optional clause and braces mark alternatives; they are not literal SQL. Unless an ORDER BY clause is present, row order is unspecified. The stock TCP server uses a bootstrap root session, while non-bootstrap embedded hosts must enforce the privileges stated on each page.