View Full Version : Assigning/Removing Primary Keys


SMatthews
11-13-2001, 08:21 AM
Is there a way to have a macro assign and/or remove a primary key from a specific table?

Pat Hartman
11-13-2001, 06:56 PM
Look up ALTER TABLE in help. You can build a query that drops/adds the primary key and then run the query in a macro.

SMatthews
11-14-2001, 10:45 AM
Thanks a lot Pat! It works great.