Thanks Kees - I managed to get it working.
On Tue, Nov 12, 2013 at 11:49 PM, Kees Nuyt <k.n...@zonnet.nl> wrote: > On Tue, 12 Nov 2013 15:00:36 +1100, SongbookDB > <shaun_thom...@songbookdb.com> wrote: > > >Ahh - ok. I was typing sqlite3 db.3sdb IN sqlite3, not command prompt. > > > >I can load and search the db now. > > > >So to drop the index 'index1' for the table 'table1', do I just type DROP > >INDEX IF EXISTS 'index1'; ? Doing so still shows the index when I load the > >database in SQLite Administrator. > > What operating system are we talking about? > > What is the exact full path to the database file? > > -- > Groet, Cordialement, Pozdrawiam, Regards, > > Kees Nuyt > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Shaun Thomson Owner - SongbookDB _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users