🚀 go-pugleaf

> Is there a way to see if a trigger or table exists in the database before
> submitting an SQL update script?
>
> Example:
> Client 1 has a database with NO BankDesc table
> Client 2 has a database WITH a BankDesc table.
>
> Need to incorporate a SQL update that is similar to:
>  If NOT exist BankDesc then Create BankDesc...
>
> If possible, then the same update could be ran on both Client 1 and Client
> 2's database with no errors.
>
> I looked at the 'Whenever SQLERROR Continue' example, but attempting a SQL
> update:
> Create table BankDesc....
> Whenever SqlError Continue
>
> via IBConsole was not successful (table already in database).

If you have another look at the SQLERROR sample you'll see that most
probably it's Embedded SQL only and the WHEN statement is Procedure
language only.


--

With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase
http://www.upscene.com

Firebird Workbench - the developer tool for Firebird
http://www.upscene.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."