Re: Question about Sequences

From: Stephen B <stephen.bell_at_cgi.ca>
Date: Wed, 5 Jun 2002 11:16:32 -0400
Message-ID: <e_pL8.6843$W74.1422756@news20.bellglobal.com>

Hi Ryan,

I'm not aware of any command that does that..remember sequences are independent objects and aren't 'connected' to a table as such..

It seems though it wouldn't take very long to drop the sequences and recreate it to START WITH n+1 ?

steve

"Ryan Gaffuri" <rgaffuri_at_cox.net> wrote in message news:1efdad5b.0206050710.4af26dd4_at_posting.google.com...
> 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:16:32 CDT