Hello Adam,

> How do I then add the field to the table if it doesn't exist, i need
> to do this in one script.

Hmmmmm... I've never done that. I always check the result of the test
SQL in program code, and based upon that I do or don't call the DDL
script that adds the field.

AFAIK, there is no such thing as conditional DDL.

Maybe somebody else has an idea here.


Greetings,
Paul Vinkenoog