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
> >
> >This table contains many records and the
At 18:08 -0600 3/17/03, Liz Buckley-Geer wrote:
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 presen
Hello.
On Mon 2003-03-17 at 18:08:08 -0600, [EMAIL PROTECTED] wrote:
> 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
> featu
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
