Re: Sequences

Ed Gillispie wrote:
>
> Does any one know of a way that you can alter the starting number of a
> sequence with out dropping the sequence.

From the SQL Language Reference Manual (ALTER SEQUENCE): "The sequence must be dropped and recreated in order to restart the sequence at a different number. Only future sequence numbers are affected by the ALTER SEQUENCE command"

-- 
Chrysalis

FABRICATI DIEM, PVNC
('To Protect and to Serve')
Terry Pratchett : "Guards Guards"