ALTER TABLE

[tom]

I want to remove the primary key in a Ms Access table.
I tried "ALTER TABLE DROP CONTRAINT PRIMARY KEY", but error occur, could
anyone pls tell me what's wrong with it?

[Filipo Novo Mór]

"tom" <tom.com@asia.com> wrote:
>
>I want to remove the primary key in a Ms Access table.
>I tried "ALTER TABLE DROP CONTRAINT PRIMARY KEY", but error occur, could
>anyone pls tell me what's wrong with it?

Tom,

The command you're trying is not correct. You have to declare the constraint's
name used to form the primary key. For sample:

ALTER TABLE TAB1 DROP CONSTRAINT Fk_Tab1;

Is the correct command to drop the primary key of a tab (Tab1) created
this way:

CREATE TABLE Tab1
(
field1 integer not null,
field2 text,
constraint Fk_Tab1 primary key (field1)
)

I hope it helps! :-)

Filipo