How recent is the IF NOT EXISTS clause for CREATE TABLE? I believe that
the shared version on my server is 3.21.33b
Jennifer
>>> IF EXISTS works with DROP and CREATE, with a later being rather
>>> recent.
>>>
>>> Sinisa
>>
>>Alternatively, you can do "select 1 from <tablename>". You either
>>get a result set of one record containing a 1 or an error indicating
>>the table doesn't exist.
>
>
>No, you get a result set consisting of "1" for *each row* of the table
>name. These queries are faster:
>
>SELECT COUNT(*) FROM tbl_name
>SELECT * FROM tbl_name WHERE 1 = 0
>
>
>Also, for CREATE TABLE, the clause is IF NOT EXISTS, not IF EXISTS.
>
>--
>Paul DuBois, paul@stripped
>
