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

• Creating tables
• Table definition
• Table configuration
• 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
• 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