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]
-----------------------------------------------------------------------------