On 31 Dec 2012, at 8:54am, Igor Korot <ikoro...@gmail.com> wrote: > I simply forgot to do it on the table creation. And now the table has > many rows...
You can easily modify a TABLE definition or even an entire database by using the SQLite shell tool to dump the database as text file of SQL commands, then edit the text file using a text editor, then use the same shell tool to read the text file back in again. Download the shell tool from the SQLite download page. Here's documentation for it: <http://www.sqlite.org/sqlite.html> You want the .dump and .read commands. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
