Ola pessoal , estou encontrando dificuldade atualizar meu banco conforme meu código, no momento em que executo o entity gera um sql estranho
IF object_id(N'[dbo].[FK_dbo.Consults_dbo.Medics_Medic_Id]', N'F') IS NOT NULL ALTER TABLE [dbo].[Consults]
DROP CONSTRAINT [FK_dbo.Consults_dbo.Medics_Medic_Id]IF EXISTS (SELECT name FROM sys.indexes
WHERE name = N'IX_Medic_Id' AND object_id = object_id(N'[dbo].[Consults]', N'U'))
DROP INDEX [IX_Medic_Id] ON [dbo].[Consults]
EXECUTE sp_rename @objname = N'dbo.Consults.Medic_Id', @newname = N'MedicId', @objtype = N'COLUMN'
Acusa esse erro
Either the parameter @objname is ambiguous or the claimed @objtype (COLUMN) is wrong.