Re: How can I alter sequence ?

From: Andreas Stephan <as.stedat_at_gmx.net>
Date: Tue, 16 Oct 2001 10:51:46 +0200
Message-ID: <9qgsbt$oev8@byz672.bayer-ag.com>

drop and re-create!

hth Andy
"Bts Rosy" <b_t_s_at_263.net> schrieb im Newsbeitrag news:005e624aaf4e0f68fcf5eea92be730cb.33476_at_mygate.mailgate.org...
> After I user sequence.nextval,the sequence.curval now is 20.
> But I want reset the curval,I hope sequence.curval=1,what I should do?
> Thanks!
>
>
> --
> Posted from [61.135.36.1]
> via Mailgate.ORG Server - http://www.Mailgate.ORG
Received on Tue Oct 16 2001 - 03:51:46 CDT

This message: [ Message body ]
Next message: Niall Litchfield: "Re: archive question --- too many archive logs generated during data load"
Previous message: Gilbert W. Pilz Jr.: "Re: Where to keep encryption key , DB?"
In reply to: Bts Rosy: "How can I alter sequence ?"
Next in thread: Valery Yourinsky: "Re: How can I alter sequence ?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US