Hi, 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.
I have read in various places that "delete from" will reset the auto increent value although I have found this not to be the case. Surely this is possible, but how ? Any help would be greatly appreciated. Thanks David _________________________________________________________________ Amazing prizes every hour with Live Search Big Snap http://www.bigsnapsearch.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
