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