How to make Primary Key in Sql Server Using Alter Statement?

Vote count:

0

I have forgot make primary key in table. Now I want to update column and make primary key to DocDay_Id Column, How can I do it?

My code is below.

I tried this syntex but it is not correct.

Create table DoctorDays

(

DocDay_Id int IDENTITY(1,1) NOT NULL,

Doc_Id int FOREIGN KEY REFERENCES Doctor(Doc_Id) NOT NULL,

Day_Id int FOREIGN KEY REFERENCES Dayss(Day_Id) NOT NULL

)

asked 2 mins ago

user3451850

3