CreateIndex in sqlparser::ast - Rust

Struct CreateIndex 

Source

pub struct CreateIndex {
Show 13 fields pub name: Option<ObjectName>, pub table_name: ObjectName, pub using: Option<IndexType>, pub columns: Vec<IndexColumn>, pub unique: bool, pub concurrently: bool, pub if_not_exists: bool, pub include: Vec<Ident>, pub nulls_distinct: Option<bool>, pub with: Vec<Expr>, pub predicate: Option<Expr>, pub index_options: Vec<IndexOption>, pub alter_options: Vec<AlterTableOperation>,
}
Expand description

CREATE INDEX statement.

index name

table name

Index type used in the statement. Can also be found inside CreateIndex::index_options depending on the position of the option within the statement.

§columns: Vec<IndexColumn>

columns included in the index

whether the index is unique

whether the index is created concurrently

IF NOT EXISTS clause

MySQL allows a subset of options normally used for ALTER TABLE:

  • ALGORITHM
  • LOCK

§
§
§
§
§
§