Re: How do we set new value for a SEQUENCE?

In article <R7fs4.7403$al3.97821_at_newsc.telia.net>, ingvar.larsson_at_gilsupport. se says...
> We have a sequence counter we wants to give new value for the next sequence
> value.

> Than we executes something like
> ALTER SEQUENCE seqcnt NEXTVAL 20;

I don't think you can alter nextval, but you can drop the sequence and create it again with "start with" option.

-- 
Gorm Larsen