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),
}

SQL option syntax used in table and server definitions.

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

The option key identifier.

value: Expr

The expression value for the option.

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

The partition column name.

range_direction: Option<PartitionRangeDirection>

Optional direction for the partition range (LEFT/RIGHT).

for_values: Vec<Expr>

Values that define the partition boundaries.

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 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 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 Eq for SqlOption

impl StructuralPartialEq for SqlOption