Subject Re: [firebird-support] How to check if a FIELD exists?!
Author Ann W. Harrison
Carol Milius wrote:
> Hi,
>
> I´ve read the posting about check if a table exists and I am wondering if
> the systems table can return if a field of a table already exists..

Sure. Look at RDB$RELATION_FIELDS. It's the junction between
RDB$FIELDS (domain information, like datatype and size) and
RDB$RELATIONS (tables and views).

Regards,


Ann