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)