Struct IndexDropStatement 

pub struct IndexDropStatement { /* private fields */ }

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(MsSqlQueryBuilder),
    r#"DROP INDEX [idx-glyph-aspect] ON [glyph]"#
);
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""#
);

Implementations

impl IndexDropStatement

pub fn new() -> Self

Construct a new IndexDropStatement

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

where T: Into<String>,

Set index name

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

where T: IntoTableRef,

Set target table

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

pub fn concurrently(&mut self) -> &mut Self

Set index to be dropped concurrently. Only available on Postgres.

impl IndexDropStatement

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

where T: SchemaBuilder,

See SchemaStatementBuilder::build

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

where T: SchemaBuilder,

See SchemaStatementBuilder::to_string

impl IndexDropStatement

pub fn mut_table<F>(&mut self, f: F) -> &mut Self

where F: Fn(Option<&TableRef>) -> Option<TableRef>,

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

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 to_string<T>(&self, schema_builder: T) -> String

where T: SchemaBuilder,

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