Developers delete a primary key constraint when they want to remove the requirement for uniqueness for the values entered in a column or a combination or columns.

C# 8.0 and .NET Core 3.0 – Modern Cross-Platform Development: Build applications with C#, .NET Core, Entity Framework Core, ASP.NET Core, and ML.NET using Visual Studio Code, 4th Edition
ASP.NET Core 3 and Angular 9: Full stack web development with .NET Core 3.1 and Angular 9, 3rd Edition
C# in Depth, 4th Edition

1. In Object Explorer, right-click the table with the primary key, and click Design (Modify in SP1 or earlier).

The table opens in Table Designer.

2. In the table grid, right-click the row with the primary key and choose Remove Primary Key to toggle the setting from on to off.

The constraint is deleted from the database when developers save the table or diagram.