Re: ???? Reseting a sequence value ????

ilepper wrote:
>
> Is it possible to reset a sequence value back to 1 again?
> So that when SEQ.NextVal will jump to 2.
>
> Anyway thanks,
>
> Ido de Lepper
> ilepper_at_fac.fbk.eur.nl

Yes, it's possible, but it's not the way i think you like it (No alter statement available).
You have to drop the sequence and create it again with the start with clause.

rgds
eugen Received on Mon Mar 02 1998 - 00:00:00 CST