>Two free tables have similar but not identical structure, with one field that autoincrements present in both. One table is empty and needs to receive data from the other table bit retain old value of field that autoincrements.
>
>What is the simplest way to turn autoincrement off momentarily and then back on?
>
>Thank you.
>
>Alex

alter table (lcTable) alter column (your autoinc field) I && removes autoinc

later on

alter table (lcTable) alter column (your autoinc field) I autoinc && adds autoinc

You can also include NextValue (lnNewValue) and STEP (lnNewStep) when turning on the autoinc, something like,: I autoinc nextvalue (lnNewValue) step (lnNewStep)


(You must have the table opened in excluive mode)