Join our webinar on Modern Data Pipelines for Smart Factories​ on Jun 26th

Register Now
CrateDB Logo
  • Product
    • Database
      • Overview
      • SQL examples
      • Integrations
      • Security
    • Data models
      • Time-series
      • Document/JSON
      • Vector
      • Full-text
      • Spatial
      • Relational
  • Use cases
    • Real-time analytics
    • Hybrid search
    • AI/ML integration
    • AI chatbots
    • Internet of Things
    • Geospatial analytics
    • Log & event analysis
  • Industries
    • Energy
    • Financial Services
    • FMCG
    • Logistics
    • Manufacturing
    • Oil, gas & mining
    • Smart city solutions
    • Technology platforms
    • Telco
    • Transportation
  • Resources
    • Customer stories
    • Academy
    • Asset library
    • Blog
    • Events
  • Developer
    • Documentation
    • Drivers and tools
    • Community
    • GitHub
    • Support
  • Pricing
  • Login
  • Get Started
Toggle Doc Menu
Search
    • CrateDB Cloud
    • Self-Managed
    • Getting Started
    • Reference Manual
      • Running CrateDB
      • Configuration
      • General Use
      • Administration
      • SQL Syntax
        • General SQL
        • SQL Statements
          • ALTER CLUSTER
          • ALTER TABLE
          • ALTER USER
          • BEGIN
          • COMMIT
          • COPY FROM
          • COPY TO
          • CREATE ANALYZER
          • CREATE BLOB TABLE
          • CREATE FUNCTION
          • CREATE INGEST RULE
          • CREATE REPOSITORY
          • CREATE SNAPSHOT
          • CREATE TABLE
          • CREATE USER
          • CREATE VIEW
          • DEALLOCATE
          • DELETE
          • DENY
          • DROP ANALYZER
          • DROP FUNCTION
          • DROP INGEST RULE
          • DROP REPOSITORY
          • DROP SNAPSHOT
          • DROP TABLE
          • DROP USER
          • DROP VIEW
          • EXPLAIN
          • GRANT
          • INSERT
          • KILL
          • OPTIMIZE
          • REFRESH
          • RESTORE SNAPSHOT
          • REVOKE
          • SELECT
          • SET and RESET
          • SET TRANSACTION
          • SET LICENSE
          • SHOW COLUMNS
          • SHOW CREATE TABLE
          • SHOW SCHEMAS
          • SHOW TABLES
          • SHOW (session settings)
          • UPDATE
      • Client Interfaces
      • CrateDB Editions
      • Appendices
    • Admin UI
    • Crash CLI
    • Drivers and Integrations
    • Support
    • Community
    • Integration Tutorials
    • Sample Applications
  Feedback

  Suggest improvement

  Edit page

  View page source

3.3

SQL Statements¶

Table of Contents

  • ALTER CLUSTER
  • ALTER TABLE
  • ALTER USER
  • BEGIN
  • COMMIT
  • COPY FROM
  • COPY TO
  • CREATE ANALYZER
  • CREATE BLOB TABLE
  • CREATE FUNCTION
  • CREATE INGEST RULE
  • CREATE REPOSITORY
  • CREATE SNAPSHOT
  • CREATE TABLE
  • CREATE USER
  • CREATE VIEW
  • DEALLOCATE
  • DELETE
  • DENY
  • DROP ANALYZER
  • DROP FUNCTION
  • DROP INGEST RULE
  • DROP REPOSITORY
  • DROP SNAPSHOT
  • DROP TABLE
  • DROP USER
  • DROP VIEW
  • EXPLAIN
  • GRANT
  • INSERT
  • KILL
  • OPTIMIZE
  • REFRESH
  • RESTORE SNAPSHOT
  • REVOKE
  • SELECT
  • SET and RESET
  • SET TRANSACTION
  • SET LICENSE
  • SHOW COLUMNS
  • SHOW CREATE TABLE
  • SHOW SCHEMAS
  • SHOW TABLES
  • SHOW (session settings)
  • UPDATE

Subscribe to the CrateDB Newsletter now

CrateDB Logo
  • Imprint
  • Contact
  • Legal
Follow us
Follow us on Twitter Follow us on LinkedIn Follow us on Facebook Follow us on Instagram Follow us on Facebook