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
          • 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
      • 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 StatementsΒΆ

Table of contents

  • 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