Re: Sequences...
From: Paul Baker <paul.baker_at_lvs.co.uk>
Date: 2000/01/26
Message-ID: <86mh6o$gdk$1_at_soap.pipex.net>#1/1
Date: 2000/01/26
Message-ID: <86mh6o$gdk$1_at_soap.pipex.net>#1/1
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 Wed Jan 26 2000 - 00:00:00 CET