Re: Sequences...

From: Steve Adams <steve.adams_at_ixora.com.au>
Date: 2000/01/30
Message-ID: <38948567.222570158@news.eagles.bbs.net.au>#1/1

Hi Guys,

Not so. You can alter the sequence to have a large negative (presumably) increment, select from it, and then reset the increment.

Regards,
Steve Adams

http://www.ixora.com.au/
http://www.oreilly.com/catalog/orinternals/
http://www.christianity.net.au/

On Wed, 26 Jan 2000 10:08:06 -0000, "Paul Baker" <paul.baker_at_lvs.co.uk> wrote:

>You can change any of the parameters that define how corresponding sequence
>numbers are generated; however, you cannot alter a sequence to change the
>starting number of a sequence. To do this, the sequence must be dropped and
>re-created.
>
>
>Michael Rosadino <mrosadino_at_yahoo.com> wrote in message
>news:IBrj4.490$yM3.44295_at_typhoon.snet.net...
>> Does anyone know how to reset a Sequence to its initial "START WITH" value
>> [for example 1] without having to drop it and recreate it in DDL??
>>
>> Thanks in advance,
>> =============================
>> Michael Rosadino,
>> (860)652-0400, x510
>> Email: mrosadino_at_med-ecom.com OR
>> mrosadino_at_yahoo.com
>>
>>
>>
>>
>
>
Received on Sun Jan 30 2000 - 00:00:00 CST