Hi

I have a DB with a table that contaings 1 million records.
I would like to add a new field of type integer (which is no
problem) and initialize this to a inc. value (1,2,3,4,5 etc).

This I would do be having to run the hole set through and do an
update on EACH field.

Is there any faster way than this ?

Michael