Subject Re: Know if a table exist before create
Author andy@camavision.com
--- In firebird-support@yahoogroups.com, "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) );
}

etc...

the site is: http://squeakycode.net if you'd like to take a look.

-Andy