SQL syntax

You can use Structured Query Language (SQL) to query your data.

This section of the documentation provides a complete SQL syntax reference for CrateDB.

Note

For introductions to CrateDB functionality, 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.

See also

General use: Data definition

General use: Data manipulation

General use: Querying

General use: Built-in functions and operators

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