Skip to content Skip to sidebar Skip to footer

Sql Azure - Could Not Able To Alter Column Type

Today I created a new table in SQL Azure portal and by default there is an Id INT column. Id ( int , PK , Not Null) When I tried to change it to BIGINT it gave me the following err

Solution 1:

Looks like the column you are trying to alter is the primary key column. You need to drop related constraints first. Something like this:ALTER TABLE [dbo].[PerformanceData] DROP CONSTRAINT Id


Post a Comment for "Sql Azure - Could Not Able To Alter Column Type"