Adding a serial column to a table. (fwd)

> > I'd like to add a serial column to a large (10 million rows) table and I want > the numbering to be as if it was always there (1-10,000,000) > > I can figure out how to do it with load and unload, but this takes forever. > > Is there a faster method using SQL / 4GL? > Add it as an integer then alter the table and make the column a serial. cheers j. _____________________________________________________________________________ Jack Parker - Hewlett Packard, DMD/IS Boise, Idaho, USA jparker@hpbs3645.boi.hp.com _____________________________________________________________________________ If anything can go wrong, fix it. To hell with Murphy. _____________________________________________________________________________ Any opinions expressed herein are my own and not those of my employers. _____________________________________________________________________________