On 13 Jul 2004 at 16:34, donjules2k wrote:

>In isql, i can run the create but not the IF to check the table does
>not exists.
>
>So how do I do this?

If the table contains some data and you want to keep it, use plain
CREATE TABLE statement. If the table exists, the statement will fail
and isql'll ignore it.
If you don't care about data and the table may exist with different
structure, use RECREATE TABLE statement.

SY, Dimitry Sibiryakov.