how to drop a primary key constraint in ms sql code example

Example: remove primary key from a table

alter table Player DROP PRIMARY KEY;