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"