Re: SQL Statement for Resetting Serial Column ?

I thought it was possible to amend the table with data to an integer column, then change it back to serial with a specified starting integer using dbaccess. Might be wrong though its a long time since I thought I did it. "Ramdas Gopinath" <rgopi@rankin.com> wrote in article <5oc0c3$mn7@cssun.mathcs.emory.edu>... > You cannot use the Alter table for resetting the Serial Column. You > can alter and add a Serial Column, but the table should not have any > Data at that time. > Gopi. > >