Enum AlterTableOperation 

pub enum AlterTableOperation {
    AddConstraint(TableConstraint),
    AddColumn {
        column_keyword: bool,
        if_not_exists: bool,
        column_def: ColumnDef,
        column_position: Option<MySQLColumnPosition>,
    },
    AddProjection {
        if_not_exists: bool,
        name: Ident,
        select: ProjectionSelect,
    },
    DropProjection {
        if_exists: bool,
        name: Ident,
    },
    MaterializeProjection {
        if_exists: bool,
        name: Ident,
        partition: Option<Ident>,
    },
    ClearProjection {
        if_exists: bool,
        name: Ident,
        partition: Option<Ident>,
    },
    DisableRowLevelSecurity,
    DisableRule {
        name: Ident,
    },
    DisableTrigger {
        name: Ident,
    },
    DropConstraint {
        if_exists: bool,
        name: Ident,
        drop_behavior: Option<DropBehavior>,
    },
    DropColumn {
        column_name: Ident,
        if_exists: bool,
        drop_behavior: Option<DropBehavior>,
    },
    AttachPartition {
        partition: Partition,
    },
    DetachPartition {
        partition: Partition,
    },
    FreezePartition {
        partition: Partition,
        with_name: Option<Ident>,
    },
    UnfreezePartition {
        partition: Partition,
        with_name: Option<Ident>,
    },
    DropPrimaryKey,
    EnableAlwaysRule {
        name: Ident,
    },
    EnableAlwaysTrigger {
        name: Ident,
    },
    EnableReplicaRule {
        name: Ident,
    },
    EnableReplicaTrigger {
        name: Ident,
    },
    EnableRowLevelSecurity,
    EnableRule {
        name: Ident,
    },
    EnableTrigger {
        name: Ident,
    },
    RenamePartitions {
        old_partitions: Vec<Expr>,
        new_partitions: Vec<Expr>,
    },
    AddPartitions {
        if_not_exists: bool,
        new_partitions: Vec<Partition>,
    },
    DropPartitions {
        partitions: Vec<Expr>,
        if_exists: bool,
    },
    RenameColumn {
        old_column_name: Ident,
        new_column_name: Ident,
    },
    RenameTable {
        table_name: ObjectName,
    },
    ChangeColumn {
        old_name: Ident,
        new_name: Ident,
        data_type: DataType,
        options: Vec<ColumnOption>,
        column_position: Option<MySQLColumnPosition>,
    },
    ModifyColumn {
        col_name: Ident,
        data_type: DataType,
        options: Vec<ColumnOption>,
        column_position: Option<MySQLColumnPosition>,
    },
    RenameConstraint {
        old_name: Ident,
        new_name: Ident,
    },
    AlterColumn {
        column_name: Ident,
        op: AlterColumnOperation,
    },
    SwapWith {
        table_name: ObjectName,
    },
    SetTblProperties {
        table_properties: Vec<SqlOption>,
    },
    OwnerTo {
        new_owner: Owner,
    },
    ClusterBy {
        exprs: Vec<Expr>,
    },
    DropClusteringKey,
    SuspendRecluster,
    ResumeRecluster,
    Algorithm {
        equals: bool,
        algorithm: AlterTableAlgorithm,
    },
    AutoIncrement {
        equals: bool,
        value: ValueWithSpan,
    },
}

An ALTER TABLE (Statement::AlterTable) operation

Variants

AddConstraint(TableConstraint)

ADD <table_constraint>

AddColumn

ADD [COLUMN] [IF NOT EXISTS] <column_def>

Fields

column_keyword: bool

[COLUMN].

if_not_exists: bool

[IF NOT EXISTS]

column_def: ColumnDef

<column_def>.

column_position: Option<MySQLColumnPosition>

MySQL ALTER TABLE only [FIRST | AFTER column_name]

AddProjection

ADD PROJECTION [IF NOT EXISTS] name ( SELECT <COLUMN LIST EXPR> [GROUP BY] [ORDER BY])

Note: this is a ClickHouse-specific operation. Please refer to ClickHouse

Fields

if_not_exists: bool

name: Ident

select: ProjectionSelect

DropProjection

DROP PROJECTION [IF EXISTS] name

Note: this is a ClickHouse-specific operation. Please refer to ClickHouse

Fields

if_exists: bool

name: Ident

MaterializeProjection

MATERIALIZE PROJECTION [IF EXISTS] name [IN PARTITION partition_name]

Note: this is a ClickHouse-specific operation. Please refer to ClickHouse

Fields

if_exists: bool

name: Ident

partition: Option<Ident>

ClearProjection

CLEAR PROJECTION [IF EXISTS] name [IN PARTITION partition_name]

Note: this is a ClickHouse-specific operation. Please refer to ClickHouse

Fields

if_exists: bool

name: Ident

partition: Option<Ident>

DisableRowLevelSecurity

DISABLE ROW LEVEL SECURITY

Note: this is a PostgreSQL-specific operation.

DisableRule

DISABLE RULE rewrite_rule_name

Note: this is a PostgreSQL-specific operation.

Fields

name: Ident

DisableTrigger

DISABLE TRIGGER [ trigger_name | ALL | USER ]

Note: this is a PostgreSQL-specific operation.

Fields

name: Ident

DropConstraint

DROP CONSTRAINT [ IF EXISTS ] <name>

Fields

if_exists: bool

name: Ident

drop_behavior: Option<DropBehavior>

DropColumn

DROP [ COLUMN ] [ IF EXISTS ] <column_name> [ CASCADE ]

Fields

column_name: Ident

if_exists: bool

drop_behavior: Option<DropBehavior>

AttachPartition

ATTACH PART|PARTITION <partition_expr> Note: this is a ClickHouse-specific operation, please refer to ClickHouse

Fields

partition: Partition

DetachPartition

DETACH PART|PARTITION <partition_expr> Note: this is a ClickHouse-specific operation, please refer to ClickHouse

Fields

partition: Partition

FreezePartition

FREEZE PARTITION <partition_expr> Note: this is a ClickHouse-specific operation, please refer to ClickHouse

Fields

partition: Partition

with_name: Option<Ident>

UnfreezePartition

UNFREEZE PARTITION <partition_expr> Note: this is a ClickHouse-specific operation, please refer to ClickHouse

Fields

partition: Partition

with_name: Option<Ident>

DropPrimaryKey

DROP PRIMARY KEY

Note: this is a MySQL-specific operation.

EnableAlwaysRule

ENABLE ALWAYS RULE rewrite_rule_name

Note: this is a PostgreSQL-specific operation.

Fields

name: Ident

EnableAlwaysTrigger

ENABLE ALWAYS TRIGGER trigger_name

Note: this is a PostgreSQL-specific operation.

Fields

name: Ident

EnableReplicaRule

ENABLE REPLICA RULE rewrite_rule_name

Note: this is a PostgreSQL-specific operation.

Fields

name: Ident

EnableReplicaTrigger

ENABLE REPLICA TRIGGER trigger_name

Note: this is a PostgreSQL-specific operation.

Fields

name: Ident

EnableRowLevelSecurity

ENABLE ROW LEVEL SECURITY

Note: this is a PostgreSQL-specific operation.

EnableRule

ENABLE RULE rewrite_rule_name

Note: this is a PostgreSQL-specific operation.

Fields

name: Ident

EnableTrigger

ENABLE TRIGGER [ trigger_name | ALL | USER ]

Note: this is a PostgreSQL-specific operation.

Fields

name: Ident

RenamePartitions

RENAME TO PARTITION (partition=val)

Fields

old_partitions: Vec<Expr>

new_partitions: Vec<Expr>

AddPartitions

Add Partitions

Fields

if_not_exists: bool

new_partitions: Vec<Partition>

DropPartitions

Fields

partitions: Vec<Expr>

if_exists: bool

RenameColumn

RENAME [ COLUMN ] <old_column_name> TO <new_column_name>

Fields

old_column_name: Ident

new_column_name: Ident

RenameTable

RENAME TO <table_name>

Fields

table_name: ObjectName

ChangeColumn

Fields

old_name: Ident

new_name: Ident

data_type: DataType

options: Vec<ColumnOption>

column_position: Option<MySQLColumnPosition>

MySQL ALTER TABLE only [FIRST | AFTER column_name]

ModifyColumn

Fields

col_name: Ident

data_type: DataType

options: Vec<ColumnOption>

column_position: Option<MySQLColumnPosition>

MySQL ALTER TABLE only [FIRST | AFTER column_name]

RenameConstraint

RENAME CONSTRAINT <old_constraint_name> TO <new_constraint_name>

Note: this is a PostgreSQL-specific operation.

Fields

old_name: Ident

new_name: Ident

AlterColumn

ALTER [ COLUMN ]

Fields

column_name: Ident

op: AlterColumnOperation

SwapWith

‘SWAP WITH <table_name>’

Note: this is Snowflake specific https://docs.snowflake.com/en/sql-reference/sql/alter-table

Fields

table_name: ObjectName

SetTblProperties

‘SET TBLPROPERTIES ( { property_key [ = ] property_val } [, …] )’

Fields

table_properties: Vec<SqlOption>

OwnerTo

OWNER TO { <new_owner> | CURRENT_ROLE | CURRENT_USER | SESSION_USER }

Note: this is PostgreSQL-specific https://www.postgresql.org/docs/current/sql-altertable.html

Fields

new_owner: Owner

ClusterBy

Snowflake table clustering options https://docs.snowflake.com/en/sql-reference/sql/alter-table#clustering-actions-clusteringaction

Fields

exprs: Vec<Expr>

DropClusteringKey

SuspendRecluster

ResumeRecluster

Algorithm

ALGORITHM [=] { DEFAULT | INSTANT | INPLACE | COPY }

MySQL-specific table alter algorithm.

Fields

equals: bool

algorithm: AlterTableAlgorithm

AutoIncrement

AUTO_INCREMENT [=] <value>

MySQL-specific table option for raising current auto increment value.

Fields

equals: bool

value: ValueWithSpan

Trait Implementations

impl Clone for AlterTableOperation

fn clone(&self) -> Self

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for AlterTableOperation

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

Formats the value using the given formatter.

impl<'de> Deserialize<'de> for AlterTableOperation

fn deserialize<__D>(__deserializer: __D) -> Result<Self, __D::Error>

where __D: Deserializer<'de>,

Deserialize this value from the given Serde deserializer.

impl Display for AlterTableOperation

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

Formats the value using the given formatter.

impl Eq for AlterTableOperation

impl Hash for AlterTableOperation

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

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 AlterTableOperation

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

fn clamp_to<R>(self, range: R) -> Self

where Self: Sized, R: ClampBounds<Self>,

🔬This is a nightly-only experimental API. (clamp_to)

Restrict a value to a certain range.

impl PartialEq for AlterTableOperation

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

Equality operator ==.

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

Inequality operator !=.

impl PartialOrd for AlterTableOperation

fn partial_cmp(&self, other: &Self) -> 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 AlterTableOperation

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

where __S: Serializer,

Serialize this value into the given Serde serializer.

impl Spanned for AlterTableOperation

partial span

Missing spans:

• AlterTableOperation::OwnerTo

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 StructuralPartialEq for AlterTableOperation

impl Visit for AlterTableOperation

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

impl VisitMut for AlterTableOperation

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