Thanks for the speedy reply. I will try it out on some test tables.
Liz
On Mon, 17 Mar 2003, Paul DuBois wrote:
> At 18:08 -0600 3/17/03, Liz Buckley-Geer wrote:
> >I have an table with a column
> >
> >numberINT NOT NULL PRIMARY KEY
> >
> >Thi
I have an table with a column
numberINT NOT NULL PRIMARY KEY
This table contains many records and there are gaps in the number
sequence. I would like to modify this column to use the AUTO INCREMENT
feature but I need to preserve the present numbering sequence (which is
monotonically in