Re: [sqlite] Does SQLITE support RESEEDing of AUTOINCREMENT fields

2007-02-18 Thread drh 
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]
-

[sqlite] Does SQLITE support RESEEDing of AUTOINCREMENT fields

2007-02-18 Thread Tom Olson 

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')?

Regards,

Tom
-- 
View this message in context: 
http://www.nabble.com/Does-SQLITE-support-RESEEDing-of-AUTOINCREMENT-fields-tf3249262.html#a9032368
Sent from the SQLite mailing list archive at Nabble.com.


-
To unsubscribe, send email to [EMAIL PROTECTED]
-