IdentityPropertyKind in sqlparser::ast

IdentityPropertyKind in sqlparser::ast - Rust

Enum IdentityPropertyKind

pub enum IdentityPropertyKind {
    Autoincrement(IdentityProperty),
    Identity(IdentityProperty),
}

Expand description

Identity is a column option for defining an identity or autoincrement column in a CREATE TABLE statement. Syntax

{ IDENTITY | AUTOINCREMENT } [ (seed , increment) | START num INCREMENT num ] [ ORDER | NOORDER ]

An identity property declared via the AUTOINCREMENT key word Example:

 AUTOINCREMENT(100, 1) NOORDER
 AUTOINCREMENT START 100 INCREMENT 1 ORDER

An identity property declared via the IDENTITY key word Example, MS SQL Server or Snowflake:

 IDENTITY(100, 1) ORDER
 IDENTITY START 100 INCREMENT 1 NOORDER