Struct IndexDropStatement 

pub struct IndexDropStatement {
    pub(crate) table: Option<TableRef>,
    pub(crate) index: TableIndex,
    pub(crate) if_exists: bool,
}

Drop an index for an existing table

Examples

use sea_query::{tests_cfg::*, *};

let index = Index::drop()
    .name("idx-glyph-aspect")
    .table(Glyph::Table)
    .to_owned();

assert_eq!(
    index.to_string(MysqlQueryBuilder),
    r#"DROP INDEX `idx-glyph-aspect` ON `glyph`"#
);
assert_eq!(
    index.to_string(PostgresQueryBuilder),
    r#"DROP INDEX "idx-glyph-aspect""#
);
assert_eq!(
    index.to_string(SqliteQueryBuilder),
    r#"DROP INDEX "idx-glyph-aspect""#
);

Fields

table: Option<TableRef>

index: TableIndex

if_exists: bool

Implementations

impl IndexDropStatement

pub fn new() -> IndexDropStatement

Construct a new IndexDropStatement

pub fn name<T>(&mut self, name: T) -> &mut IndexDropStatement

where T: Into<String>,

Set index name

pub fn table<T>(&mut self, table: T) -> &mut IndexDropStatement

where T: IntoTableRef,

Set target table

pub fn if_exists(&mut self) -> &mut IndexDropStatement

impl IndexDropStatement

pub fn build<T>(&self, schema_builder: T) -> String

where T: SchemaBuilder,

See SchemaStatementBuilder::build

pub fn build_any(&self, schema_builder: &dyn SchemaBuilder) -> String

See SchemaStatementBuilder::build_any

pub fn to_string<T>(&self, schema_builder: T) -> String

where T: SchemaBuilder,

See SchemaStatementBuilder::to_string

Trait Implementations

impl Clone for IndexDropStatement

fn clone(&self) -> IndexDropStatement

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for IndexDropStatement

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

Formats the value using the given formatter.

impl Default for IndexDropStatement

fn default() -> IndexDropStatement

Returns the “default value” for a type.

impl SchemaStatementBuilder for IndexDropStatement

fn build<T>(&self, schema_builder: T) -> String

where T: SchemaBuilder,

Build corresponding SQL statement for certain database backend and return SQL string

fn build_any(&self, schema_builder: &dyn SchemaBuilder) -> String

Build corresponding SQL statement for certain database backend and return SQL string

fn to_string<T>(&self, schema_builder: T) -> String

where T: SchemaBuilder,

Build corresponding SQL statement for certain database backend and return SQL string

impl StatementBuilder for IndexDropStatement

fn build(&self, db_backend: &DatabaseBackend) -> Statement

Method to call in order to build a Statement