Subject | Re: Know if a table exist before create |
---|---|
Author | andy@camavision.com |
Post date | 2004-07-15T00:20Z |
--- In firebird-support@yahoogroups.com, "donjules2k" <giulio@g...> wrote:
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
> what about doing the same for procedures, views etc? Do i do the sameIt's a little non-standard, and windows only, but you can try my
> 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
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