IndexConstraint in sqlparser::ast::table_constraints

IndexConstraint in sqlparser::ast::table_constraints - Rust

Struct IndexConstraint

pub struct IndexConstraint {
    pub display_as_key: bool,
    pub name: Option<Ident>,
    pub index_type: Option<IndexType>,
    pub columns: Vec<IndexColumn>,
    pub index_options: Vec<IndexOption>,
}

Expand description

MySQLs index definition for index creation. Not present on ANSI so, for now, the usage is restricted to MySQL, as no other dialects that support this syntax were found.

{INDEX | KEY} [index_name] [index_type] (key_part,...) [index_option]...

Whether this index starts with KEY (true) or INDEX (false), to maintain the same syntax.

Index name.

§columns: Vec<IndexColumn>

Referred column identifier list.

Optional index options such as USING; see IndexOption. Options applied to the index (e.g., COMMENT, WITH options).