>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 everytime I need it is what I really need to be doing.
>
>Thanks
>Mark

Look in the Help for ALTER TABLE.