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
  • FLOAT_VECTOR
  • Geographic types
  • Type casting
  • PostgreSQL compatibility
• System columns
• Generated columns
  • Generation expressions
  • Last modified dates
  • Partitioning
• Constraints
  • PRIMARY KEY
  • NULL
  • 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
  • Renaming columns
  • Closing and opening tables
  • Renaming tables
  • Reroute shards