Enum ColumnOption

pub enum ColumnOption {
    Null,
    NotNull,
    Default(Expr),
    Unique {
        is_primary: bool,
        characteristics: Option<ConstraintCharacteristics>,
    },
    ForeignKey {
        foreign_table: ObjectName,
        referred_columns: Vec<Ident>,
        on_delete: Option<ReferentialAction>,
        on_update: Option<ReferentialAction>,
        characteristics: Option<ConstraintCharacteristics>,
    },
    Check(Expr),
    DialectSpecific(Vec<Token>),
    CharacterSet(ObjectName),
    Comment(String),
    OnUpdate(Expr),
    Generated {
        generated_as: GeneratedAs,
        sequence_options: Option<Vec<SequenceOptions>>,
        generation_expr: Option<Expr>,
        generation_expr_mode: Option<GeneratedExpressionMode>,
        generated_keyword: bool,
    },
    Options(Vec<SqlOption>),
}

ColumnOptions are modifiers that follow a column definition in a CREATE TABLE statement.

Variants

Null

NULL

NotNull

NOT NULL

Default(Expr)

DEFAULT <restricted-expr>

Unique

{ PRIMARY KEY | UNIQUE } [<constraint_characteristics>]

Fields

is_primary: bool

characteristics: Option<ConstraintCharacteristics>

ForeignKey

A referential integrity constraint ([FOREIGN KEY REFERENCES <foreign_table> (<referred_columns>) { [ON DELETE <referential_action>] [ON UPDATE <referential_action>] | [ON UPDATE <referential_action>] [ON DELETE <referential_action>] } [<constraint_characteristics>] ).

Fields

foreign_table: ObjectName

referred_columns: Vec<Ident>

on_delete: Option<ReferentialAction>

on_update: Option<ReferentialAction>

characteristics: Option<ConstraintCharacteristics>

Check(Expr)

CHECK (<expr>)

DialectSpecific(Vec<Token>)

Dialect-specific options, such as:

• MySQL’s AUTO_INCREMENT or SQLite’s AUTOINCREMENT
• …

CharacterSet(ObjectName)

Comment(String)

OnUpdate(Expr)

Generated

Generateds are modifiers that follow a column definition in a CREATE TABLE statement.

Fields

generated_as: GeneratedAs

sequence_options: Option<Vec<SequenceOptions>>

generation_expr: Option<Expr>

generation_expr_mode: Option<GeneratedExpressionMode>

generated_keyword: bool

false if ‘GENERATED ALWAYS’ is skipped (option starts with AS)

Options(Vec<SqlOption>)

BigQuery specific: Explicit column options in a view 1 or table 2 Syntax

OPTIONS(description="field desc")

Trait Implementations

impl Clone for ColumnOption

fn clone(&self) -> ColumnOption

Returns a copy of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Debug for ColumnOption

fn fmt(&self, f: &mut Formatter<'_>) -> Result<(), Error>

Formats the value using the given formatter.

impl Display for ColumnOption

fn fmt(&self, f: &mut Formatter<'_>) -> Result<(), Error>

Formats the value using the given formatter.

impl Hash for ColumnOption

fn hash<__H>(&self, state: &mut __H)

where __H: Hasher,

Feeds this value into the given Hasher.

fn hash_slice<H>(data: &[Self], state: &mut H)

where H: Hasher, Self: Sized,

Feeds a slice of this type into the given Hasher.

impl Ord for ColumnOption

fn cmp(&self, other: &ColumnOption) -> Ordering

This method returns an Ordering between self and other.

fn max(self, other: Self) -> Self

where Self: Sized,

Compares and returns the maximum of two values.

fn min(self, other: Self) -> Self

where Self: Sized,

Compares and returns the minimum of two values.

fn clamp(self, min: Self, max: Self) -> Self

where Self: Sized,

Restrict a value to a certain interval.

impl PartialEq for ColumnOption

fn eq(&self, other: &ColumnOption) -> bool

Tests for self and other values to be equal, and is used by ==.

fn ne(&self, other: &Rhs) -> bool

Tests for !=. The default implementation is almost always sufficient, and should not be overridden without very good reason.

impl PartialOrd for ColumnOption

fn partial_cmp(&self, other: &ColumnOption) -> Option<Ordering>

This method returns an ordering between self and other values if one exists.

fn lt(&self, other: &Rhs) -> bool

Tests less than (for self and other) and is used by the < operator.

fn le(&self, other: &Rhs) -> bool

Tests less than or equal to (for self and other) and is used by the <= operator.

fn gt(&self, other: &Rhs) -> bool

Tests greater than (for self and other) and is used by the > operator.

fn ge(&self, other: &Rhs) -> bool

Tests greater than or equal to (for self and other) and is used by the >= operator.

impl Eq for ColumnOption

impl StructuralPartialEq for ColumnOption