> Its easy enough checking to see if there exists a field in a table.
>
> Select count(*) from rdb$relation_fields ...etc
>
> But how can I NOT alter the table (ie add a new field) if the field
> exists ? (written as a SQL statement using iSQL IB6)

If the field exists, you get error message and table will NOT be altered.
isql script will continue after error.


Ivan
http://www.volny.cz/iprenosil/interbase