Upcoming Webinar: Real-Time Energy Grid Control Based on Big Data

Register now
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
          • 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
      • 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:4.8
master latest 4.8 4.7 3.3

SQL StatementsΒΆ

Table of contents

  • 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

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