rod@... wrote:

>
> 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)
>

There isn't an obvious way you can do this with isql scripts. ISQL is really
limited on this basic point. It may be possible to get round this limitation
with some ingenuity, but that ingenuity may be better spent using another tool
or mechanism to solve the problem.


Paul
--

Paul Reeves
http://www.ibphoenix.com
taking InterBase further