Interface IDeleteExpressionRoot

The root expression for a DELETE operation

Namespace: FluentMigrator.Builders.Delete
Assembly: FluentMigrator.Abstractions.dll
Syntax
public interface IDeleteExpressionRoot

Methods

| Edit this page View Source

Column(string)

Specify the column to delete

Declaration
IDeleteColumnFromTableSyntax Column(string columnName)
Parameters
Type Name Description
string columnName

The column name
Returns
Type Description
IDeleteColumnFromTableSyntax

The next step
| Edit this page View Source

DefaultConstraint()

Deletes a default constraint from a column

Declaration
IDeleteDefaultConstraintOnTableSyntax DefaultConstraint()
Returns
Type Description
IDeleteDefaultConstraintOnTableSyntax

The next step
| Edit this page View Source

ForeignKey()

Specify that a foreign key with a default name should be deleted

Declaration
IDeleteForeignKeyFromTableSyntax ForeignKey()
Returns
Type Description
IDeleteForeignKeyFromTableSyntax

The next step
| Edit this page View Source

ForeignKey(string)

Specify that a foreign key with the given name should be deleted

Declaration
IDeleteForeignKeyOnTableSyntax ForeignKey(string foreignKeyName)
Parameters
Type Name Description
string foreignKeyName

The foreign key name
Returns
Type Description
IDeleteForeignKeyOnTableSyntax

The next step
| Edit this page View Source

FromTable(string)

Deletes data from a table

Declaration
IDeleteDataOrInSchemaSyntax FromTable(string tableName)
Parameters
Type Name Description
string tableName

The table name
Returns
Type Description
IDeleteDataOrInSchemaSyntax

The next step
| Edit this page View Source

Index()

Deletes an index, based on the naming convention in effect

Declaration
IDeleteIndexForTableSyntax Index()
Returns
Type Description
IDeleteIndexForTableSyntax

The next step
| Edit this page View Source

Index(string)

Deletes an index

Declaration
IDeleteIndexForTableSyntax Index(string indexName)
Parameters
Type Name Description
string indexName

the name of the index
Returns
Type Description
IDeleteIndexForTableSyntax

The next step
| Edit this page View Source

PrimaryKey(string)

Deletes a named Primary Key from a table

Declaration
IDeleteConstraintOnTableSyntax PrimaryKey(string primaryKeyName)
Parameters
Type Name Description
string primaryKeyName

The name of the primary key
Returns
Type Description
IDeleteConstraintOnTableSyntax

The next step
| Edit this page View Source

Schema(string)

Specify the schema to delete

Declaration
void Schema(string schemaName)
Parameters
Type Name Description
string schemaName

The name of the schema
| Edit this page View Source

Sequence(string)

Delete a sequence with the given name

Declaration
IInSchemaSyntax Sequence(string sequenceName)
Parameters
Type Name Description
string sequenceName

The sequence name
Returns
Type Description
IInSchemaSyntax

The next step
| Edit this page View Source

Table(string)

Specify the table to delete

Declaration
IInSchemaSyntax Table(string tableName)
Parameters
Type Name Description
string tableName

The table name
Returns
Type Description
IInSchemaSyntax

The next step
| Edit this page View Source

UniqueConstraint()

Deletes a named Unique Constraint from a table based on the naming convention in effect

Declaration
IDeleteConstraintOnTableSyntax UniqueConstraint()
Returns
Type Description
IDeleteConstraintOnTableSyntax

The next step
| Edit this page View Source

UniqueConstraint(string)

Deletes a named Unique Constraint From a table

Declaration
IDeleteConstraintOnTableSyntax UniqueConstraint(string constraintName)
Parameters
Type Name Description
string constraintName

The constraint name
Returns
Type Description
IDeleteConstraintOnTableSyntax

The next step