Creating and Modifying PRIMARY KEY Constraints

Note To modify a PRIMARY KEY constraint using Transact-SQL or SQL-DMO, you must first delete the existing PRIMARY KEY constraint and then re-create it with the new definition. ...

technet.microsoft.com