AW: Influence a Sequence

Christoph Weser wrote : > >Hello! > >Short question: Is it possible to increment a sequence manually? >Example: My sequence goes 1000, 1001, 1002, but after a >special event it >should go on with 2000, 2001, 2002,... > >Any other solution than dropping and recreating the sequence? > >Thanx a l

Re: Influence a Sequence

ALTER SEQUENCE... ? Or drop and recreate Or read all the values you don't need... robert > --- Ursprüngliche Nachricht --- > Von: Christoph Weser <[EMAIL PROTECTED]> > An: "maxdb (E-Mail)" > Betreff: Influence a Sequence > Datum: Wed, 1 Jun 2005 15:09:50 +

Influence a Sequence

Hello! Short question: Is it possible to increment a sequence manually? Example: My sequence goes 1000, 1001, 1002, but after a special event it should go on with 2000, 2001, 2002,... Any other solution than dropping and recreating the sequence? Thanx a lot! Chris -- MaxDB Discussion Mail