> -----Original Message----- > From: Jacob Engstrand [mailto:[EMAIL PROTECTED] > Sent: Tuesday, March 30, 2004 11:18 AM > To: Will Leshner > Cc: Forum SQLite > Subject: Re: [sqlite] Dropping an old index > > Yes, I thought about that, but the quotes are not part of the name in > the SQLITE_MASTER table. Of course, I did try to "DROP INDEX > 'addressesZipIndex'" too, but no success... :(
My results look different using sqlite 2.8.8: sqlite> create table foo (id text); sqlite> create index 'fooindex' on 'foo' (id); sqlite> select * from sqlite_master; type name tbl_name rootpage sql ---------- ---------- ---------- ---------- -------------------------- table foo foo 3 create table foo (id text) index 'fooindex' foo 4 create index 'fooindex' on sqlite> drop index "'fooindex'"; sqlite> select * from sqlite_master; type name tbl_name rootpage sql ---------- ---------- ---------- ---------- -------------------------- table foo foo 3 create table foo (id text) -Ken
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
