alter table dbo.Tb_Customer_Assess drop column id alter table dbo.Tb_Customer_Assess add id int primary key identity(1,1)