Struct CreateIndex 

pub struct CreateIndex {
    pub name: Identifier,
    pub table: TableRef,
    pub columns: Vec<IndexColumn>,
    pub unique: bool,
    pub if_not_exists: bool,
    pub using: Option<String>,
    pub clustered: Option<String>,
    pub concurrently: bool,
    pub where_clause: Option<Box<Expression>>,
    pub include_columns: Vec<Identifier>,
    pub with_options: Vec<(String, String)>,
    pub on_filegroup: Option<String>,
}

CREATE INDEX statement

Fields

name: Identifier

table: TableRef

columns: Vec<IndexColumn>

unique: bool

if_not_exists: bool

using: Option<String>

clustered: Option<String>

TSQL CLUSTERED/NONCLUSTERED modifier

concurrently: bool

PostgreSQL CONCURRENTLY modifier

where_clause: Option<Box<Expression>>

PostgreSQL WHERE clause for partial indexes

include_columns: Vec<Identifier>

PostgreSQL INCLUDE columns

with_options: Vec<(String, String)>

TSQL WITH options (e.g., allow_page_locks=on)

on_filegroup: Option<String>

TSQL ON filegroup or partition scheme (e.g., ON PRIMARY, ON X([y]))

Implementations

impl CreateIndex

pub fn new(name: impl Into<String>, table: impl Into<String>) -> Self

Trait Implementations

impl Clone for CreateIndex

fn clone(&self) -> CreateIndex

Returns a duplicate of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Debug for CreateIndex

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

Formats the value using the given formatter.

impl<'de> Deserialize<'de> for CreateIndex

fn deserialize<__D>(__deserializer: __D) -> Result<Self, __D::Error>

where __D: Deserializer<'de>,

Deserialize this value from the given Serde deserializer.

impl PartialEq for CreateIndex

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

fn serialize<__S>(&self, __serializer: __S) -> Result<__S::Ok, __S::Error>

where __S: Serializer,

Serialize this value into the given Serde serializer.

impl StructuralPartialEq for CreateIndex