If you can max it out in a few years, you've got a bunch of records running through there :)

Like Fred said, you can do ALTER TABLE to drop the field and then ALTER TABLE again to add it back, but me thinks copying the file is easier.

ZAP has to write the entire new file once, ALTER TABLE method will have to write the file twice (I think), and it would put the new field at the end of the field list...which may or may not matter to you.

And since the empty file should be small, performance differences should be negligible.

>Granted it would take a few years to max them out.
>
>When zap didn't reset the nextvalue too, it got me looking in help on how to reset the nexvalue.(still haven't found it) But your suggestion on creating an empty table every time I need it is what I really need to be doing.
>