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
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
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
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
4 matches
Mail list logo