Remove Primary Key + MS SQL Server

[obrienkev]

Hi all,

I need to update a field value which is also the primary key.

So I have to remove the Primary Key constraint.

I tried the below but gives error..

ALTER TABLE student DROP CONSTRAINT ffnumber

also tried...

ALTER TABLE student DISABLE PRIMARY KEY;

error is "incorrect syntax neat the keyword 'PRIMARY'"

Any ideas? Using MS SQL Server.

Thanks.

[MarkR]

Firstly, updating the primary key normally indicates a design flaw. Secondly, updating the primary key should be possible, provided there is no other row with the same value.

Thirdly, you seem to be using the syntax from some other database rather than MSSQL - look in their documentation.

DDL is notoriously incompatible between database servers.

Mark