Re: [sqlite] IF EXISTS when using DROP TABLE

2006-10-23 Thread Alexandre Guion
You can use the PRAGMA query to test if a table exists or not. "PRAGMA table_info(`tablename`)" -- Alex Guion Software Engineer OrbNetworks, Inc. www.orb.com [EMAIL PROTECTED] wrote: Thank you. My version does not. I had used one of the archives to search for this issue, but the thread I

Re: [sqlite] IF EXISTS when using DROP TABLE

2006-10-23 Thread epankoke
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

Re: [sqlite] IF EXISTS when using DROP TABLE

2006-10-23 Thread Adriano Ferreira
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: 'n

[sqlite] IF EXISTS when using DROP TABLE

2006-10-23 Thread epankoke
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 w