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 SQL
- SQL Statements
ALTER CLUSTERALTER PUBLICATIONALTER ROLEALTER SERVERALTER TABLEALTER USERANALYZEBEGINCLOSECOMMITCOPY FROMCOPY TOCREATE ANALYZERCREATE BLOB TABLECREATE FOREIGN TABLECREATE FUNCTIONCREATE PUBLICATIONCREATE REPOSITORYCREATE ROLECREATE SCHEMACREATE SERVERCREATE SNAPSHOTCREATE SUBSCRIPTIONCREATE TABLECREATE TABLE ASCREATE USERCREATE USER MAPPINGCREATE VIEWDEALLOCATEDECLAREDELETEDENYDISCARDDROP ANALYZERDROP FOREIGN TABLEDROP FUNCTIONDROP PUBLICATIONDROP REPOSITORYDROP ROLEDROP SCHEMADROP SERVERDROP SNAPSHOTDROP SUBSCRIPTIONDROP TABLEDROP USERDROP USER MAPPINGDROP VIEWENDEXPLAINFETCHGRANTINSERTKILLOPTIMIZEREFRESHRESTORE SNAPSHOTREVOKESELECTSETandRESETSET AND RESET SESSION AUTHORIZATIONSET TRANSACTIONSHOW (session settings)SHOW COLUMNSSHOW CREATE TABLESHOW SCHEMASSHOW TABLESSTART TRANSACTIONUPDATEVALUESWITH