| Subject | Re: [firebird-support] Re: How to update table structure with SQL? |
|---|---|
| Author | Doug Chamberlin |
| Post date | 2009-06-23T14:12:15Z |
Emil Totev wrote:
exists - just query the system tables using standard SQL. These can also
be used to detect existing fields in tables.
Going back to your original problem - wouldn't this solve it? (albeit
with a bit more work that the if exists... syntax you are used to.)
> Firebird has the "CREATE OR ALTER" syntax for changes to tables that might be missing.As Emil has mentioned, Firebird has a way to detect whether a table
> You can also get information about the existing fields from the system tables and act accordingly.
exists - just query the system tables using standard SQL. These can also
be used to detect existing fields in tables.
Going back to your original problem - wouldn't this solve it? (albeit
with a bit more work that the if exists... syntax you are used to.)