How to drop column with FluentMigrator?

Question

I am using .Net4.5 and C#, I am working on one of database migrations using FluentMigrator. I am able to alter tables and add columns by using

Alter.Table("Items").InSchema("Pricing")
            .AddColumn("CanBe").AsBoolean().NotNullable()

However I need to drop some existing columns and nor DeleteColumn nor DropColumn methods are not on IAlterTableAddColumnOrAlterColumnOrSchemaSyntax interface.

How do I drop columns using FluentMigrator?

score 69 · Accepted Answer · answered Jul 07 '16 at 11:02

69

Found it myself:

It has to go as separate statement.

Alter.Table("Items").InSchema("Pricing")
        .AddColumn("CanBe").AsBoolean().NotNullable();

Delete.Column("AllowSubscription").FromTable("Items").InSchema("Pricing");

answered Jul 07 '16 at 11:02

Matas Vaitkevicius

58,075
31
238
265

3

Shame there isn't an option for `.DeleteColumn` within `Alter.Table` :( – Caltor Aug 22 '18 at 15:38
2

@Caltor Indeed. I think it is due to this being 'translated' into SQL statements. – Matas Vaitkevicius Aug 23 '18 at 01:32
1

What do you do if there's a foreign key? – Kellen Stuart Nov 20 '20 at 19:05

How to drop column with FluentMigrator?

1 Answers1

Linked