How to Remove Primary Key SQL

Primary keys are an important part of a table design. When redesigning tables, there may come a time when a primary key needs to be removed. For some database administrators, this comes after a complete redesign of a database or because performance is low. These steps help you remove a primary key in SQL Server.

Instructions

1. Open SQL Server Management Studio. Click the Windows "Start" button, choose "Programs," and then choose Microsoft SQL Server. From the menu, choose "SQL Server Management Studio."

2. Open the table. On the left side of the screen, a list of databases appear in the Server Explorer. Choose the table you wish to change. Click the "Data" menu at the top of the window and choose "Open Table Definition." This opens the table designer.

3. Remove the primary key. Right-click the row with the primary key and choose "Remove Primary Key" from the menu.

References

• Microsoft