Struct ForeignKeyDropStatement 

pub struct ForeignKeyDropStatement {
    pub(crate) foreign_key: TableForeignKey,
    pub(crate) table: Option<TableRef>,
}

Drop a foreign key constraint for an existing table

Examples

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

let foreign_key = ForeignKey::drop()
    .name("FK_character_font")
    .table(Char::Table)
    .to_owned();

assert_eq!(
    foreign_key.to_string(MysqlQueryBuilder),
    r#"ALTER TABLE `character` DROP FOREIGN KEY `FK_character_font`"#
);
assert_eq!(
    foreign_key.to_string(PostgresQueryBuilder),
    r#"ALTER TABLE "character" DROP CONSTRAINT "FK_character_font""#
);
// Sqlite does not support modification of foreign key constraints to existing tables

Fields

foreign_key: TableForeignKey

table: Option<TableRef>

Implementations

impl ForeignKeyDropStatement

pub fn new() -> Self

Construct a new ForeignKeyDropStatement

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

where T: Into<String>,

Set foreign key name

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

where T: IntoTableRef,

Set key table and referencing table

impl ForeignKeyDropStatement

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

Trait Implementations

impl Clone for ForeignKeyDropStatement

fn clone(&self) -> ForeignKeyDropStatement

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for ForeignKeyDropStatement

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

Formats the value using the given formatter.

impl Default for ForeignKeyDropStatement

fn default() -> ForeignKeyDropStatement

Returns the “default value” for a type.

impl SchemaStatementBuilder for ForeignKeyDropStatement

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