Jump to content

ALTER TABLE Change Primary Key Field?


Recommended Posts

Is there any way in SQL to change which field is the primary key? Then also drop the field from having a primary key?


Thanks in advance.


I should probably add I am using Access database at the moment...

DROP INDEX indexFIeld ON Table1

doesn't seem to work

Edited by astralaaron
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...