Thanks for the info, Norm. That looks very helpful.
"Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> wrote in message
news:E2F6A70FE45242488C865C3BC1245DA70410BA02_at_lnewton.leeds.lfs.co.uk...
> Hi Jim,
>
> This link will give you enough information on how to reset a sequence
> (without invalidating anything which depends on it) because you will
> need to drop and recreate the sequence otherwise, and you'll need to
> build some dynamic sql to start it off at the correct number.
>
> http://www.jlcomp.demon.co.uk/faq/resetseq.html
>
> Cheers,
> Norm.
>
> -------------------------------------
> Norman Dunbar
> Database/Unix administrator
> Lynx Financial Systems Ltd.
> mailto:Norman.Dunbar_at_LFS.co.uk
> Tel: 0113 289 6265
> Fax: 0113 289 3146
> URL: http://www.Lynx-FS.com
> -------------------------------------
>
Received on Wed Aug 13 2003 - 08:58:00 CDT
