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
  • Basics
  • Schemas
  • Naming restrictions
  • Advanced use
• Data types
  • Classification
  • boolean
  • Character types
  • Numeric types
  • ip
  • Date and time types
  • geo_point
  • geo_shape
  • object
  • array
  • Special character types
  • Object Identifier Types
  • Type conversion
  • Type aliases
• 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
  • Configuration
• 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