Primary Key Constraint Name

[swstran]

Is it possible to drop primary key of an Access table using SQL? What I really meant was that the ALTER TABLE DROP CONSTRAINT statement can be used to drop a primary key, but it requires the constraint name. Since our primary key was created within Access, we don't know what is the constraint name that system had assigned.

 

[RickSpr]

In Access, the constraint name is supposed to be the same as the index name. For primary keys, the default is always "PrimaryKey". You can check it by opening the table in Design View, then choosing View>Indexes from the menu.

I've never actually done this. Let me know if it works. Rick Sprague

 

[swstran]

Thanks Rick,

It works just beautiful the way I wanted. Now I can apply the followings:

ALTER TABLE <table_name> DROP CONSTRAINT PrimaryKey

and this will drop the primary key created by MS Access.

Again, thanks a lot.