Reference

Complete documentation about Genji’s SQL syntax

ALTER TABLE

Manage tables and table constraints

CREATE INDEX

Define a new index

CREATE SEQUENCE

Define a new sequence

Transactions

Manage transactions

CREATE TABLE

Define a new table

DELETE

Delete documents

DROP INDEX

Delete an index and all of its content

DROP SEQUENCE

Delete a sequence

DROP TABLE

Delete a table and all of its content

EXPLAIN

Generate query plan

INSERT

Insert documents

REINDEX

Reindex tables, indexes or everything

SELECT

Query the database

UPDATE

Update documents


Last modified October 21, 2021: Move back to docs (991ad67)