Re: SQL-Script question

Quoting Tracy Nedd... } } I would agree with Dave's solution, but with one enhancement. } Steps 1 - 6 I would keep, assuming that the serial column is initialized } to 800. Then the only step needed would be to: } 7) ALTER TABLE tabname MODIFY (serial_column SMALLINT); } This, I believe, would achieve the desired results. I hope this helps! } That's a good idea (I'm embarrased that I didn't think of it). Thanks for the suggestion. DAS -- Dave Snyder @ Bell Atlantic - Philadelphia, PA WORK: ddx85qr@boots.bell-atl.com HOME: dave@das13.snide.com