How do I drop a column and create a new one instead of renaming in EF Core?

Sometimes EF can think you want to rename a column, as opposed to creating a column if the types are the same.

It's not an exact science so either create a migration to first delete the column, apply, then create another to add a new one so EF picks up on them as separate operations, or I would just change the migration manually.

In case of the latter option, use the MigrationBuilder.AddColumn method to add the States column & then change RenameColumn to DropColumn and drop Invites:

protected override void Up(MigrationBuilder migrationBuilder)
{
    migrationBuilder.DropColumn(
        name: "Info",
        table: "Articles");

    migrationBuilder.DropColumn(
        name: "Invites",
        table: "Articles");

    migrationBuilder.AddColumn(
        name: "States",
        table: "Articles");
}

In case you ever want to revert the migration, remember to also change the Down(MigrationBuilder migrationBuilder) method so that it carries out the reverse of your updated Up(...) method, not the old one:

protected override void Down(MigrationBuilder migrationBuilder)
{
    migrationBuilder.AddColumn(
        name: "Info",
        table: "Articles");

    migrationBuilder.AddColumn(
        name: "Invites",
        table: "Articles");

    migrationBuilder.DropColumn(
        name: "States",
        table: "Articles");
}