On Mon, Dec 31, 2012 at 8:13 PM, Ward Willats <sqlite-us...@wardco.com>wrote:
> > On Dec 31, 2012, at 12:57 AM, Simon Slavin <slav...@bigfraud.org> wrote: > > > > > 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. > > > Or, if you want to do it "live:" use ALTER TABLE to rename the existing > table, CREATE TABLE to make the table with the FK you want, INSERT SELECT > to bring the records from the renamed table to the new table, and DROP > TABLE to get rid of the renamed original. > and VACUUM to get rid of the extra space on disk > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- ˙uʍop-ǝpısdn sı ɹoʇıuoɯ ɹnoʎ 'sıɥʇ pɐǝɹ uɐɔ noʎ ɟı _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users