Set primary key to existing table column in SQL Server

Question

Dear Programmerwhy this command is not execute on sql server 2008r2ALTER TABLE MCLnewIdADD CONSTRAINT pkMCLUserName NVARCHAR PRIMARY KEY MCLUserNamegive this error messageIncorrect syntax near NVARCHAR Error 102 SQLSTATE 42000 Severity 15 MsgState 1 Line 2What will be right command

Shashikant · Accepted Answer

You need to make column not nullable before adding constraint primary key to it like belowALTER TABLE tableNameALTER COLUMN id INT NOT NULLGOALTER TABLE tableNameADD PRIMARY KEY idGOI hope this will help you out

Set primary key to existing table column in SQL Server

Company

Explore

Follow us

Contact Us