Re: converting an existing column to auto increment

2003-03-18 Thread Liz Buckley-Geer
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 there are

converting an existing column to auto increment

2003-03-17 Thread Liz Buckley-Geer
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

Re: converting an existing column to auto increment

2003-03-17 Thread Benjamin Pflugmann
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 feature but

Re: converting an existing column to auto increment

2003-03-17 Thread Paul DuBois
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