Struct CreateIndex
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:
ALGORITHMLOCK