lundi 18 juillet 2016

DbMigration Sql Alter Table

I've been trying to the change a simple name property on my PK "Id" Column of my table. I'm using Entity Framework. Problem is I can't seem to get the Sql right...I've tried:

Sql("ALTER TABLE Customers COLUMN RENAME id to Id Int");
Sql("ALTER TABLE Customers RENAME id to Id Int");
Sql("ALTER TABLE Customers sp_rename id to Id");

I always get an incorrect syntax error.

I've tried searching for the answer, but none of the solutions have worked, anybody have an idea?

Aucun commentaire:

Enregistrer un commentaire