Hi Naomi

Here are the answers to your questions, just out of curiosity, as I've decided to delete my old records from the original table, then append the backed-up ones (so I won't have to change the procedure if I ever have to change the table structure again.)

Ok, now questions.
1) How many indexes this table has?

It had 2 indexes: one regular on a foreign key, another primary (the one I'm trying to delete.)

2) Is it part of DBC?

It is.

3) Instead of ALTER TABLE, can you open the table exclusively, remove PK using DELETE TAG command, then create it?

Or may be DELETE TAG ALL, then re-create? Just an idea. Is database on the Network? It may be something is still in memory when you're trying to do things in this sequence.

I hadn't thought of that. I'll give it a try for my sanity's sake, after I've devised a way to just batch append the record as I've described to you in the beginning of this post...

Thanks for your time,