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
        • Data definition
        • Data manipulation
        • Querying
        • Built-in functions and operators
        • User-defined functions
        • Blobs
        • Optimistic Concurrency Control
        • Information schema
      • Administration
      • SQL syntax
      • 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

General useΒΆ

This section of the documentation covers any feature primarily of interest to a general user.

Table of contents

  • 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
    • Selecting data
    • Joins
    • Union
    • Refresh
    • Fulltext search
    • Geo search
  • Built-in functions and operators
    • Scalar functions
    • Aggregation
    • Arithmetic operators
    • Bit 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

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