crate.io Logo
  • Products
    • CrateDB Overview
    • CrateDB Cloud
    • CrateDB Edge
    • CrateDB On-Premises
    • CrateOM
    • 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.0
master latest 5.0 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
    • START TRANSACTION
    • 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
    • DELETE
    • DENY
    • DISCARD
    • DROP ANALYZER
    • DROP FUNCTION
    • DROP PUBLICATION
    • DROP REPOSITORY
    • DROP SNAPSHOT
    • DROP SUBSCRIPTION
    • DROP TABLE
    • DROP USER
    • DROP VIEW
    • END
    • 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
    • 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
  • CrateOM
  • 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 LinkedIn Follow us on Facebook Follow us on YouTube 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