SQL syntax

CrateDB uses SQL to query documents.

This section of the documentation provides a full SQL syntax reference.

Note

If you’re just getting started with a particular part of CrateDB, we recommend you consult the appropriate top-level section of the documentation. The SQL syntax reference assumes a basic familiarity with the relevant parts of CrateDB.

• General SQL
  • Constraints
  • Value expressions
  • Lexical structure
• SQL Statements
  • ALTER CLUSTER
  • ALTER TABLE
  • ALTER USER
  • ANALYZE
  • BEGIN
  • COMMIT
  • COPY FROM
  • COPY TO
  • CREATE ANALYZER
  • CREATE BLOB TABLE
  • CREATE FUNCTION
  • CREATE REPOSITORY
  • CREATE SNAPSHOT
  • CREATE TABLE
  • CREATE TABLE AS
  • CREATE USER
  • CREATE VIEW
  • DEALLOCATE
  • DELETE
  • DENY
  • DISCARD
  • DROP ANALYZER
  • DROP CONSTRAINT
  • DROP FUNCTION
  • DROP REPOSITORY
  • DROP SNAPSHOT
  • DROP TABLE
  • DROP USER
  • DROP VIEW
  • EXPLAIN
  • GRANT
  • INSERT
  • KILL
  • OPTIMIZE
  • REFRESH
  • RESTORE SNAPSHOT
  • REVOKE
  • SELECT
  • SET and RESET
  • SET LICENSE
  • SET AND RESET SESSION AUTHORIZATION
  • SET TRANSACTION
  • SHOW COLUMNS
  • SHOW CREATE TABLE
  • SHOW SCHEMAS
  • SHOW TABLES
  • SHOW (session settings)
  • UPDATE
  • VALUES