"uk webdev" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I've searched high and low and I cannot find any information on how > to reset an auto increment value to 1. There appears to be no tuncate > command and the usual alter table command for Mysql is also invalid.
Are you talking about INTEGER PRIMIARY KEY AUTOINCREMENT field? Run this statement: delete from sqlite_sequence where name='YourTableName'; For more details, see http://sqlite.org/autoinc.html -- With best wishes, Igor Tandetnik With sufficient thrust, pigs fly just fine. However, this is not necessarily a good idea. It is hard to be sure where they are going to land, and it could be dangerous sitting under them as they fly overhead. -- RFC 1925 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
