CrateDB Logo
  • Product
    • Database
      • Overview
      • SQL examples
      • Integrations
      • Security
    • Data models
      • Time-series
      • Document/JSON
      • Vector
      • Full-text
      • Spatial
      • Relational
  • Use cases
    • Real-time analytics
    • Hybrid search
    • AI/ML integration
    • AI chatbots
    • Internet of Things
    • Geospatial analytics
    • Log & event analysis
  • Industries
    • Energy
    • Financial Services
    • FMCG
    • Logistics
    • Manufacturing
    • Oil, gas & mining
    • Smart city solutions
    • Technology platforms
    • Telco
    • Transportation
  • Resources
    • Customer stories
    • Academy
    • Asset library
    • Blog
    • Events
  • Developer
    • Documentation
    • Drivers and tools
    • Community
    • GitHub
    • Support
  • Pricing
  • Login
  • Get Started
Toggle Doc Menu
Search
    • CrateDB Cloud
    • Self-Managed
    • Getting Started
    • Reference Manual
      • Running CrateDB
      • 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 Crate
        • Built-in Functions and Operators
        • User-Defined Functions
        • Blobs
        • Optimistic Concurrency Control
        • Information Schema
      • Administration
      • SQL Syntax
      • Client Interfaces
      • CrateDB Editions
      • Appendices
    • Admin UI
    • Crash CLI
    • Drivers and Integrations
    • Support
    • Community
    • Integration Tutorials
    • Sample Applications
  Feedback

  Suggest improvement

  Edit page

  View page source

3.3

Data DefinitionΒΆ

Table of Contents

  • Creating Tables
    • Introduction
    • Schemas
    • Naming Restrictions
  • Data Types
    • Classification
    • boolean
    • string
    • Numeric Types
    • ip
    • timestamp
    • geo_point
    • geo_shape
    • object
    • array
    • Type Conversion
    • Type aliases
  • System Columns
  • Generated Columns
  • Constraints
    • Primary Key
    • Not Null
  • 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)
    • Create a Custom Analyzer
    • Extending a Bultin Analyzer
  • Fulltext Analyzers
    • Overview
    • Built-in Analyzers
    • Built-in Tokenizers
    • Built-in Token Filters
    • Builtin Char Filter
  • Show Create Table
  • Views
    • Introduction: Creating Views
    • Querying Views
    • Dropping Views
  • Altering Tables
    • Updating Parameters
    • Adding Columns
    • Closing and Opening Tables
    • Renaming Tables
    • Reroute Shards

Subscribe to the CrateDB Newsletter now

CrateDB Logo
  • Imprint
  • Contact
  • Legal
Follow us
Follow us on Twitter Follow us on LinkedIn Follow us on Facebook Follow us on Instagram Follow us on Facebook