How do I modify the primary key?

You can modify the primary key of a table by changing the column order, index name, clustered option, or fill factor. Requires ALTER permission on the table. Open the Table Designer for the table whose primary key you want to modify, right-click in the Table Designer, and choose Indexes/Keys from the shortcut menu.
For More Information Please Refer:


You May Also Like to Read: