| Subject | Metadata check BEFORE alter | 
|---|---|
| Author | rod@myiafrica.com | 
| Post date | 2001-10-17T09:20:50Z | 
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)
            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)