Remove Primary Key constraint from a column(sql server 2005)

Question

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.

Answer 1

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;

Answer 2

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;

Answer 3

YOu realize that dropping a primary key is usually a bad idea, right?