Enum AlterTableOperation 

pub enum AlterTableOperation {
    AddConstraint {
        constraint: TableConstraint,
        not_valid: bool,
    },
    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 {
        has_column_keyword: bool,
        column_names: Vec<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 {
        drop_behavior: Option<DropBehavior>,
    },
    DropForeignKey {
        name: Ident,
        drop_behavior: Option<DropBehavior>,
    },
    DropIndex {
        name: Ident,
    },
    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>,
    },
    ReplicaIdentity {
        identity: ReplicaIdentity,
    },
    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: RenameTableNameKind,
    },
    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,
    },
    Lock {
        equals: bool,
        lock: AlterTableLock,
    },
    AutoIncrement {
        equals: bool,
        value: ValueWithSpan,
    },
    ValidateConstraint {
        name: Ident,
    },
    SetOptionsParens {
        options: Vec<SqlOption>,
    },
}

An ALTER TABLE (Statement::AlterTable) operation

Variants

AddConstraint

ADD <table_constraint> [NOT VALID]

Fields

constraint: TableConstraint

not_valid: bool

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> [ , <column_name>, ... ] [ CASCADE ]

Fields

has_column_keyword: bool

column_names: Vec<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

MySQL Snowflake

Fields

drop_behavior: Option<DropBehavior>

DropForeignKey

DROP FOREIGN KEY <fk_symbol>

MySQL Snowflake

Fields

name: Ident

drop_behavior: Option<DropBehavior>

DropIndex

DROP INDEX <index_name>

Fields

name: Ident

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>

ReplicaIdentity

REPLICA IDENTITY { DEFAULT | USING INDEX index_name | FULL | NOTHING }

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

Fields

identity: ReplicaIdentity

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: RenameTableNameKind

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

Lock

LOCK [=] { DEFAULT | NONE | SHARED | EXCLUSIVE }

MySQL-specific table alter lock.

Fields

equals: bool

lock: AlterTableLock

AutoIncrement

AUTO_INCREMENT [=] <value>

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

Fields

equals: bool

value: ValueWithSpan

ValidateConstraint

VALIDATE CONSTRAINT <name>

Fields

name: Ident

SetOptionsParens

Arbitrary parenthesized SET options.

Example:

SET (scale_factor = 0.01, threshold = 500)`

PostgreSQL

Fields

options: Vec<SqlOption>

Trait Implementations

impl Clone for AlterTableOperation

fn clone(&self) -> AlterTableOperation

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<(), Error>

Formats the value using the given formatter.

impl Display for AlterTableOperation

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

Formats the value using the given formatter.

impl Hash for AlterTableOperation

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 AlterTableOperation

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

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

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

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

where V: Visitor,

impl VisitMut for AlterTableOperation

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

where V: VisitorMut,

impl Eq for AlterTableOperation

impl StructuralPartialEq for AlterTableOperation