I created a table in my Azure SQL Database, Part of the code is here..
CREATE TABLE [dbo].[DEVAppointments](
[ClusterInd] [int] IDENTITY(1,1) CONSTRAINT PK_CI_DEVAppt PRIMARY KEY CLUSTERED NOT NULL,
[dbPatFlowArcCnt] [int] NOT NULL,
I now wish to make the column dbPatFlowArcCnt a Primary Key column too but don't wish to drop the table as it has lots of data in it.
When I use this sql however..
alter table DEVAppointments drop CONSTRAINT PK_CI_DEVAppt
alter table DEVAppointments add primary key (PK_CI_DEVAppt, dbPatFlowArcCnt)
I get this error
Msg 40054, Level 16, State 2, Line 9
Tables without a clustered index are not supported in this version of SQL Server. Please create a clustered index and try again.
Msg 3727, Level 16, State 0, Line 9
Could not drop constraint. See previous errors.