crate.io Logo
  • Products
    • CrateDB Overview
    • CrateDB Cloud
    • CrateDB Edge
    • CrateDB On-Premises
    • Pricing
    • Get CrateDB
  • Customers
    • Success Stories
    • Use Cases
    • Industries
  • Docs
  • Resources
    • Blog
    • Events
    • Newsletter
    • Videos
    • Webinars
    • White Papers
  • Community
  • Login
  • Get CrateDB
Toggle Doc Menu
Search
    • Install CrateDB
    • CrateDB
    • Reference
      • Concepts
      • CLI tools
      • Configuration
      • General use
      • Administration
      • SQL syntax
        • General SQL
        • SQL Statements
      • Client interfaces
      • Appendices
    • Clients and Tools
    • Admin UI
    • Crash CLI
    • CrateDB Cloud
      • Tutorials
      • How-To Guides
      • Reference
      • Croud CLI
    • JDBC
    • PHP DBAL
    • PHP PDO
    • Python
    • .NET Npgsql
    • Sample Applications
    • Support
v:5.2
master latest 5.2 5.1 4.8 3.3

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 USER
    • ANALYZE
    • BEGIN
    • CLOSE
    • COMMIT
    • COPY FROM
    • COPY TO
    • CREATE ANALYZER
    • CREATE BLOB TABLE
    • CREATE FUNCTION
    • CREATE PUBLICATION
    • CREATE REPOSITORY
    • CREATE SNAPSHOT
    • CREATE SUBSCRIPTION
    • CREATE TABLE
    • CREATE TABLE AS
    • CREATE USER
    • CREATE VIEW
    • DEALLOCATE
    • DECLARE
    • DELETE
    • DENY
    • DISCARD
    • DROP ANALYZER
    • DROP FUNCTION
    • DROP PUBLICATION
    • DROP REPOSITORY
    • DROP SNAPSHOT
    • DROP SUBSCRIPTION
    • DROP TABLE
    • DROP USER
    • 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

Feedback

How helpful was this page?
New issue Edit on GitHub View on GitHub

Product

  • CrateDB Overview
  • CrateDB Cloud
  • CrateDB Edge
  • CrateDB On-Premises
  • Compare
  • Pricing
  • Download
  • CrateDB Cloud Login

Customers

  • Success Stories
  • Use Cases
  • Industries

Resources

  • Blog
  • Events
  • Content Library
  • Newsletter
  • Videos
  • Webinars
  • White Papers

Developers

  • Get Started
  • Reference
  • How-To Guides
  • Support
  • SQL 99 Docs
  • Community
  • Github
  • Contribute

Company

  • About us
  • Jobs
  • Partners
  • Newsroom
  • Security
  • Contact

Follow us

Follow us on Twitter Follow us on Twitter Follow us on LinkedIn Follow us on LinkedIn Follow us on Facebook Follow us on Facebook Follow us on YouTube Follow us on YouTube Follow us on GitHub Follow us on GitHub
  • Legal
  • Privacy Policy
  • Imprint

erdf
  • Legal
  • Privacy Policy
  • Imprint
  • European Regional Development Funds Logo
crate.io Logo

Subscribe to the Crate.io Newsletter now