Set sequences to next value after data import

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Wed, 13 Aug 2003 10:51:28 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA70410BA02@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 - 04:51:28 CDT