Alter table add identity column

If there is exising filed you want to change

Alter

Table temp_inscsv Drop Column id

 

if not want to add a brand new use pnly following:-

Alter Table temp_inscsv Add id int identity(1,1) primary key