On 12 Nov 2013, at 4:00am, 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. No need to use single quotes around entity names. In fact, it's incorrect to do so. Single quotes are for strings. Apart from that, yes, you can type any SQL command, end it with a semi-colon, then hit return and the shell tool will execute the command. This includes SELECT commands. You can split a command onto many lines. The shell tool is looking for that semi-colon before it thinks you've finished the command. The SQLite shell tool is written by the SQLite team and if it disagrees with any other SQLite program, the shell tool is probably the correct one. As I've proved with my own programming errors many times. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
