Enum SqlOption 

pub enum SqlOption {
    Clustered(TableOptionsClustered),
    Ident(Ident),
    KeyValue {
        key: Ident,
        value: Expr,
    },
    Partition {
        column_name: Ident,
        range_direction: Option<PartitionRangeDirection>,
        for_values: Vec<Expr>,
    },
    Comment(CommentDef),
    TableSpace(TablespaceOption),
    NamedParenthesizedList(NamedParenthesizedList),
}

Variants

Clustered(TableOptionsClustered)

Clustered represents the clustered version of table storage for MSSQL.

https://learn.microsoft.com/en-us/sql/t-sql/statements/create-table-azure-sql-data-warehouse?view=aps-pdw-2016-au7#TableOptions

Ident(Ident)

Single identifier options, e.g. HEAP for MSSQL.

https://learn.microsoft.com/en-us/sql/t-sql/statements/create-table-azure-sql-data-warehouse?view=aps-pdw-2016-au7#TableOptions

KeyValue

Any option that consists of a key value pair where the value is an expression. e.g.

WITH(DISTRIBUTION = ROUND_ROBIN)

Fields

key: Ident

value: Expr

Partition

One or more table partitions and represents which partition the boundary values belong to, e.g.

PARTITION (id RANGE LEFT FOR VALUES (10, 20, 30, 40))

https://learn.microsoft.com/en-us/sql/t-sql/statements/create-table-azure-sql-data-warehouse?view=aps-pdw-2016-au7#TablePartitionOptions

Fields

column_name: Ident

range_direction: Option<PartitionRangeDirection>

for_values: Vec<Expr>

Comment(CommentDef)

Comment parameter (supports = and no = syntax)

TableSpace(TablespaceOption)

MySQL TableSpace option https://dev.mysql.com/doc/refman/8.4/en/create-table.html

NamedParenthesizedList(NamedParenthesizedList)

An option representing a key value pair, where the value is a parenthesized list and with an optional name e.g.

UNION = (tbl_name[,tbl_name]…) https://dev.mysql.com/doc/refman/8.4/en/create-table.html ENGINE = ReplicatedMergeTree(‘/table_name’,‘{replica}’, ver) https://clickhouse.com/docs/engines/table-engines/mergetree-family/replication ENGINE = SummingMergeTree([columns]) https://clickhouse.com/docs/engines/table-engines/mergetree-family/summingmergetree

Trait Implementations

impl Clone for SqlOption

fn clone(&self) -> SqlOption

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for SqlOption

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

Formats the value using the given formatter.

impl<'de> Deserialize<'de> for SqlOption

fn deserialize<__D>( __deserializer: __D, ) -> Result<SqlOption, <__D as Deserializer<'de>>::Error>

where __D: Deserializer<'de>,

Deserialize this value from the given Serde deserializer.

impl Display for SqlOption

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

Formats the value using the given formatter.

impl Hash for SqlOption

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 SqlOption

fn cmp(&self, other: &SqlOption) -> 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 SqlOption

fn eq(&self, other: &SqlOption) -> 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 SqlOption

fn partial_cmp(&self, other: &SqlOption) -> 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 Serialize for SqlOption

fn serialize<__S>( &self, __serializer: __S, ) -> Result<<__S as Serializer>::Ok, <__S as Serializer>::Error>

where __S: Serializer,

Serialize this value into the given Serde serializer.

impl Spanned for SqlOption

fn span(&self) -> Span

Return the [Span] (the minimum and maximum Location) for this AST node, by recursively combining the spans of its children.

impl Visit for SqlOption

fn visit<V>(&self, visitor: &mut V) -> ControlFlow<<V as Visitor>::Break>

where V: Visitor,

impl VisitMut for SqlOption

fn visit<V>(&mut self, visitor: &mut V) -> ControlFlow<<V as VisitorMut>::Break>

where V: VisitorMut,

impl Eq for SqlOption

impl StructuralPartialEq for SqlOption