drop the primary key using a query

[prasadbuddhika]

i tried to drop the primary key of the table using

alter table customer drop primary key

but it says Msg 156, Level 15, State 1, Line 1 Incorrect syntax near the keyword 'primary'. what might be the problem

[Shrinivas Singh]

try this alter table customer drop constraintname constraintname is the name of the primary key constraint

[Wayne Porter]

I have the same problem too. What are you suppose to use.