remove primary key sql server code example

Example 1: sql drop primary key

ALTER TABLE [table_name] DROP CONSTRAINT [primary_key_name]

Example 2: remove primary key from a table

alter table Player DROP PRIMARY KEY;