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
          • 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 5.2 5.1 4.8 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
  • 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