Subject Re: Know if a table exist before create
--- In, "donjules2k" <giulio@g...> wrote:
> what about doing the same for procedures, views etc? Do i do the same
> and just ignore the error messages? My only worry is that eventually
> I'll have lots of errors to ignore and in the long list of errors they
> may be a genuine error which would get overlooked.
> Giulio
It's a little non-standard, and windows only, but you can try my
sqlWin program. it adds a script language on top of standard sql, so
you can write:

if ! tableExists('bob') {
create table bob (name varchar(50) );


the site is: if you'd like to take a look.