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(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

impl IndexDropStatement

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

See SchemaStatementBuilder::build

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

See SchemaStatementBuilder::build_any

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

See SchemaStatementBuilder::to_string

Trait Implementations

impl Clone for IndexDropStatement

fn clone(&self) -> IndexDropStatement

Returns a copy 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: SchemaBuilder>(&self, schema_builder: T) -> String

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

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