Question about Sequences

Someone on my project recently truncated all the tables in one of our databases and imported new data. The problem is that the our sequence generators did not reset to match the highest sequence we have in our primary keys, so we keep hitting a unique constraint.

Is there a command to reset sequences to the highest value in the table?
Id prefer to run this dynamically than have to find the highest value for each sequence add set it to n + 1. This would be time consuming.

Thanks. Received on Wed Jun 05 2002 - 10:10:33 CDT