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] -----------------------------------------------------------------------------
