Thank you. My version does not. I had used one of the archives to search for this issue, but the thread I found did not have an answer to the question.
-- Eric Pankoke Founder / Lead Developer Point Of Light Software http://www.polsoftware.com/ -------------- Original message ---------------------- From: "Adriano Ferreira" <[EMAIL PROTECTED]> > On 10/23/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > If I use the syntax "DROP TABLE tablename" everything is good, except of > course I get a "no such table" error if the table does not exist. However, > if I > use the syntax "DROP TABLE IF EXISTS tablename", then I get the following > error: > 'near "EXISTS": syntax error'. Anyone have a thought as to what's going on? > Is > this a known issue? > > It looks like the same issue on the thread "Trouble with ALTER > TABLE/ADD", answered by drh. Are you sure your version of SQLite > supports "DROP TABLE IF EXISTS"? > > The URL http://www.sqlite.org/cvstrac/wiki?p=UnsupportedSql says > > IF EXISTS function, e.g. "DROP TABLE IF EXISTS temp;" > > Added in 3.3 > > ----------------------------------------------------------------------------- > To unsubscribe, send email to [EMAIL PROTECTED] > ----------------------------------------------------------------------------- > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
