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

Data definitionΒΆ

This section provides an overview of how to create tables and perform other data-definition related operations with CrateDB.

See also

General use: Data manipulation

General use: Querying

Table of contents

  • Creating tables
    • Table definition
    • Table configuration
  • Data types
    • Overview
    • Primitive types
    • Container types
    • Geographic types
    • Type casting
    • PostgreSQL compatibility
  • System columns
  • Generated columns
    • Generation expressions
    • Last modified dates
    • Partitioning
  • Constraints
    • Primary key
    • Not null
    • Check
  • Storage
    • Column store
  • Partitioned tables
    • Introduction
    • Creation
    • Information schema
    • Insert
    • Update
    • Delete
    • Querying
    • Alter
    • Limitations
    • Consistency notes related to concurrent DML statement
  • Sharding
    • Introduction
    • Number of shards
    • Routing
  • Replication
    • Table configuration
    • Shard recovery
    • Underreplication
  • Shard allocation filtering
    • Settings
    • Special attributes
  • Column policy
    • strict
    • dynamic
  • Fulltext indices
    • Index definition
    • Disable indexing
    • Plain index (default)
    • Creating a custom analyzer
    • Extending a built-in analyzer
  • Fulltext analyzers
    • Overview
    • Built-in analyzers
    • Built-in tokenizers
    • Built-in token filters
    • Built-in char filter
  • Show Create Table
  • Views
    • Creating views
    • Querying views
    • Dropping views
  • Altering tables
    • Updating parameters
    • Adding columns
    • Closing and opening tables
    • Renaming tables
    • Reroute shards

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