SyntaxFix
Write A Post
Hire A Developer
Questions
This was the easiest solution that I found.
Select Table
Press ALT + F1
Scroll and view constraint names
Then the query is simple:
ALTER TABLE [Table] DROP CONSTRAINT [Constraint]
https://www.sqlservergeeks.com/sql-server-dropping-a-primary-key-constraint-in-sql-server-is-it-easy-may-be-may-be-not/