Tom Olson <[EMAIL PROTECTED]> wrote: > Hello, > > Is there a function or PRAGMA that tells the database engine to recalculate > the next sequence number for an AUTOINCREMENT column of a table (i.e. PRAGMA > reseed('tablename')? >
You can UPDATE the sqlite_sequence table to do this. -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------