Enum sqlparser::ast::AlterTableOperation

pub enum AlterTableOperation {
    AddConstraint(TableConstraint),
    AddColumn {
        column_keyword: bool,
        if_not_exists: bool,
        column_def: ColumnDef,
    },
    DisableRowLevelSecurity,
    DisableRule {
        name: Ident,
    },
    DisableTrigger {
        name: Ident,
    },
    DropConstraint {
        if_exists: bool,
        name: Ident,
        cascade: bool,
    },
    DropColumn {
        column_name: Ident,
        if_exists: bool,
        cascade: bool,
    },
    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>,
    },
    RenameConstraint {
        old_name: Ident,
        new_name: Ident,
    },
    AlterColumn {
        column_name: Ident,
        op: AlterColumnOperation,
    },
    SwapWith {
        table_name: ObjectName,
    },
    SetTblProperties {
        table_properties: Vec<SqlOption>,
    },
}

An ALTER TABLE (Statement::AlterTable) operation

Variants

AddConstraint(TableConstraint)

ADD <table_constraint>

AddColumn

Fields

column_keyword: bool

[COLUMN].

if_not_exists: bool

[IF NOT EXISTS]

column_def: ColumnDef

<column_def>.

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

DisableRowLevelSecurity

DISABLE ROW LEVEL SECURITY

Note: this is a PostgreSQL-specific operation.

DisableRule

Fields

name: Ident

DISABLE RULE rewrite_rule_name

Note: this is a PostgreSQL-specific operation.

DisableTrigger

Fields

name: Ident

DISABLE TRIGGER [ trigger_name | ALL | USER ]

Note: this is a PostgreSQL-specific operation.

DropConstraint

Fields

if_exists: bool

name: Ident

cascade: bool

DROP CONSTRAINT [ IF EXISTS ] <name>

DropColumn

Fields

column_name: Ident

if_exists: bool

cascade: bool

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

DropPrimaryKey

DROP PRIMARY KEY

Note: this is a MySQL-specific operation.

EnableAlwaysRule

Fields

name: Ident

ENABLE ALWAYS RULE rewrite_rule_name

Note: this is a PostgreSQL-specific operation.

EnableAlwaysTrigger

Fields

name: Ident

ENABLE ALWAYS TRIGGER trigger_name

Note: this is a PostgreSQL-specific operation.

EnableReplicaRule

Fields

name: Ident

ENABLE REPLICA RULE rewrite_rule_name

Note: this is a PostgreSQL-specific operation.

EnableReplicaTrigger

Fields

name: Ident

ENABLE REPLICA TRIGGER trigger_name

Note: this is a PostgreSQL-specific operation.

EnableRowLevelSecurity

ENABLE ROW LEVEL SECURITY

Note: this is a PostgreSQL-specific operation.

EnableRule

Fields

name: Ident

ENABLE RULE rewrite_rule_name

Note: this is a PostgreSQL-specific operation.

EnableTrigger

Fields

name: Ident

ENABLE TRIGGER [ trigger_name | ALL | USER ]

Note: this is a PostgreSQL-specific operation.

RenamePartitions

Fields

old_partitions: Vec<Expr>

new_partitions: Vec<Expr>

RENAME TO PARTITION (partition=val)

AddPartitions

Fields

if_not_exists: bool

new_partitions: Vec<Partition>

Add Partitions

DropPartitions

Fields

partitions: Vec<Expr>

if_exists: bool

RenameColumn

Fields

old_column_name: Ident

new_column_name: Ident

RENAME [ COLUMN ] <old_column_name> TO <new_column_name>

RenameTable

Fields

table_name: ObjectName

RENAME TO <table_name>

ChangeColumn

Fields

old_name: Ident

new_name: Ident

data_type: DataType

options: Vec<ColumnOption>

RenameConstraint

Fields

old_name: Ident

new_name: Ident

RENAME CONSTRAINT <old_constraint_name> TO <new_constraint_name>

Note: this is a PostgreSQL-specific operation.

AlterColumn

Fields

column_name: Ident

op: AlterColumnOperation

ALTER [ COLUMN ]

SwapWith

Fields

table_name: ObjectName

‘SWAP WITH <table_name>’

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

SetTblProperties

Fields

table_properties: Vec<SqlOption>

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

Trait Implementations

impl Clone for AlterTableOperation

fn clone(&self) -> AlterTableOperation

Returns a copy 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 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: &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 + PartialOrd,

Restrict a value to a certain interval.

impl PartialEq for AlterTableOperation

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

This method tests for self and other values to be equal, and is used by ==.

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

This method 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

This method tests less than (for self and other) and is used by the < operator.

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

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

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

This method tests greater than (for self and other) and is used by the > operator.

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

This method 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 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>

impl Eq for AlterTableOperation

impl StructuralPartialEq for AlterTableOperation