crate.io Logo
  • Products
    • CrateDB
    • CrateDB Cloud
    • Get CrateDB
  • Customers
    • Success Stories
    • Use Cases
  • Compare
  • Company
    • About us
    • Careers
    • Partners
    • Newsroom
    • Newsletter
    • Events
    • Contact us
  • Resources
    • Documentation
    • Videos
    • Webinars
    • White Papers
    • Community
  • Blog
  •  
  • Login
  • Contact us
Toggle Doc Menu
Search Documentation
    • CrateDB
      • Tutorials
      • How-To Guides
      • Reference
        • Concepts
          • Joins
            • Types of join
            • Joins in CrateDB
          • Clustering
            • Components of a CrateDB Node
            • Multi-node setup: Clusters
            • Cluster behavior
            • Application use case
          • Storage and consistency
            • Data storage
            • Atomic on document level
            • Durability
            • Addressing of documents
            • Consistency
            • Cluster meta data
          • Resiliency
            • Overview
        • CLI tools
          • crate
            • Synopsis
            • Options
            • Signal handling
            • Example
          • crate-node
            • Synopsis
            • Commands
            • Options
        • Configuration
          • Node-specific settings
            • Basics
            • Node types
            • Read-only node
            • Hosts
            • Ports
            • Paths
            • Plug-ins
            • CPU
            • Memory
            • Garbage collection
            • Authentication
            • Secured communications (SSL/TLS)
            • Cross-origin resource sharing (CORS)
            • Blobs
            • Repositories
            • Queries
            • Javascript language
            • Custom attributes
          • Cluster-wide settings
            • Non-runtime cluster-wide settings
            • Collecting stats
            • Shard limits
            • Usage data collector
            • Graceful stop
            • Bulk operations
            • Discovery
            • Routing allocation
            • Recovery
            • Memory management
            • Query circuit breaker
            • Field data circuit breaker
            • Request circuit breaker
            • Accounting circuit breaker
            • Stats circuit breakers
            • Total circuit breaker
            • Thread pools
            • Metadata
          • Session settings
            • Usage
            • Supported session settings
          • Logging
            • Application logging
            • JVM logging
          • Environment variables
            • Application variables
            • JVM variables
        • General use
          • Data definition
            • Creating tables
            • Data types
            • System columns
            • Generated columns
            • Constraints
            • Storage
            • Partitioned tables
            • Sharding
            • Replication
            • Shard allocation filtering
            • Column policy
            • Fulltext indices
            • Fulltext analyzers
            • Show Create Table
            • Views
            • Altering tables
          • Data manipulation
            • Inserting data
            • Updating data
            • Deleting data
            • Import and export
          • Querying Crate
            • Selecting data
            • Joins
            • Union All
            • Refresh
            • Fulltext search
            • Geo search
          • Built-in functions and operators
            • Scalar functions
            • Aggregation
            • Arithmetic operators
            • Table functions
            • Comparison operators
            • Array comparisons
            • Subquery expressions
            • Window functions
          • User-defined functions
            • CREATE OR REPLACE
            • Supported types
            • Overloading
            • Determinism
            • DROP FUNCTION
            • Supported languages
          • Blobs
            • Creating a table for blobs
            • Custom location for storing blob data
            • List
            • Altering a blob table
            • Deleting a blob table
            • Using blob tables
          • Optimistic Concurrency Control
            • Introduction
            • Optimistic update
            • Optimistic delete
            • Known limitations
          • Information schema
            • Access
            • Virtual tables
        • Administration
          • System information
            • Cluster
            • Nodes
            • Node checks
            • Shards
            • Segments
            • Jobs, operations, and logs
            • Cluster checks
            • Health
            • Repositories
            • Snapshots
            • Snapshot Restore
            • Summits
            • Users
            • Allocations
            • Shard table permissions
            • Sys jobs tables permissions
            • pg_stats
          • Runtime configuration
          • User management
            • Introduction
            • CREATE USER
            • ALTER USER
            • DROP USER
            • List users
          • Privileges
            • Privilege types
            • Hierarchical inheritance of privileges
            • Behavior of GRANT, DENY and REVOKE
            • List privileges
          • Authentication
            • Authentication Methods
            • Host Based Authentication (HBA)
          • Secured communications (SSL/TLS)
            • SSL/TLS configuration
            • Setting up a Keystore/Truststore with a certificate chain
          • Optimization
            • Introduction
            • Multiple table optimization
            • Partition optimization
            • Segments upgrade
          • Jobs management
          • JMX monitoring
            • Setup
            • Using Docker
            • JMX Beans
            • Exposing JMX via HTTP
          • Snapshots
            • Snapshot
            • Restore
            • Cleanup
            • Requirements for using HDFS repositories
          • Cloud discovery
            • Amazon EC2 discovery
            • Microsoft Azure discovery
          • Usage Data Collector
            • Technical information
            • Admin UI tracking
            • Configuration
            • How to disable UDC
        • SQL syntax
          • General SQL
            • Constraints
            • Value expressions
            • Lexical structure
          • SQL Statements
            • ALTER CLUSTER
            • ALTER TABLE
            • ALTER USER
            • ANALYZE
            • BEGIN
            • COMMIT
            • COPY FROM
            • COPY TO
            • CREATE ANALYZER
            • CREATE BLOB TABLE
            • CREATE FUNCTION
            • CREATE REPOSITORY
            • CREATE SNAPSHOT
            • CREATE TABLE
            • CREATE USER
            • CREATE VIEW
            • DEALLOCATE
            • DELETE
            • DENY
            • DISCARD
            • DROP ANALYZER
            • DROP CONSTRAINT
            • DROP FUNCTION
            • DROP REPOSITORY
            • DROP SNAPSHOT
            • DROP TABLE
            • DROP USER
            • DROP VIEW
            • 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
        • Client interfaces
          • HTTP endpoint
            • Introduction
            • Parameter substitution
            • Default schema
            • Column types
            • Bulk operations
            • Error handling
          • PostgreSQL wire protocol
            • Introduction
            • Server compatibility and implementation status
            • Client compatibility
            • Implementation differences
        • Editions
          • CrateDB
            • Enterprise features
            • Node limitation
          • CrateDB Community Edition
        • Appendices
          • Release Notes
            • Versions
            • Older Versions
          • SQL compatibility
            • Implementation notes
            • Unsupported features and functions
          • SQL standard compliance
          • Resiliency Issues
            • Known issues
            • Fixed issues
      • 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:4.4
master latest 4.4 3.3

SQL Statements¶

Table of contents

  • ALTER CLUSTER
  • ALTER TABLE
  • ALTER USER
  • ANALYZE
  • BEGIN
  • COMMIT
  • COPY FROM
  • COPY TO
  • CREATE ANALYZER
  • CREATE BLOB TABLE
  • CREATE FUNCTION
  • CREATE REPOSITORY
  • CREATE SNAPSHOT
  • CREATE TABLE
  • CREATE USER
  • CREATE VIEW
  • DEALLOCATE
  • DELETE
  • DENY
  • DISCARD
  • DROP ANALYZER
  • DROP CONSTRAINT
  • DROP FUNCTION
  • DROP REPOSITORY
  • DROP SNAPSHOT
  • DROP TABLE
  • DROP USER
  • DROP VIEW
  • 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

Feedback

How helpful was this page?
New issue Edit on GitHub View on GitHub
  • Product
  • CrateDB
  • CrateDB Cloud
  • CrateDB Editions
  • Compare
  • Download
  • CrateDB Cloud Login
  • Pricing
  • Use Cases
  • Success Stories
  • Use Cases
  • IoT & Sensors
  • Time Series
  • Geospatial Tracking
  • Cybersecurity
  • Resources
  • Blog
  • Content Library
  • Videos
  • Webinars
  • White Papers
  • Developers
  • Get Started
  • Reference
  • How-To Guides
  • Support
  • SQL 99 Docs
  • Community
  • Github
  • Contribute
  • Company
  • About us
  • Jobs
  • Events
  • Newsletter
  • Partners
  • Press
  • Security
  • Contact
  • Legal
  • Privacy Policy
  • Imprint
  • European Regional Development Funds Logo
crate.io Logo