Remove Primary Key constraint from a column

How to remove primary key constraint from column?

I have table t_data_dnefrc table. In that I have AccountNbr column which is primary key. I 开发者_如何学编程want to remove Primary key constraint for that column.

You need to drop the constraint, the name of which can be found in the Keys folder of the table in SQL Management Studio.

ALTER TABLE t_data_dnefrc
DROP CONSTRAINT constraintName;

Note: this is mysql way - check Marcus's answer for the correct answer to OP's question.

ALTER TABLE t_data_dnefrc DROP PRIMARY KEY;