| Subject | Re: How to update table structure with SQL? |
|---|---|
| Author | neighbour.kerry |
| Post date | 2009-06-23T21:45:35Z |
--- In firebird-support@yahoogroups.com, Doug Chamberlin <dougchamberlin@...> wrote:
No problems, that is what I was doing anyway - I just had trouble believing Firebird could not do this, and had the feeling I was going down the wrong path.
>Well - not really. You can certainly run a SELECT query to see if a system object exists, but then Firebird can do nothing with it. ie there is no IF...which is why I have to use Delphi.
> As Emil has mentioned, Firebird has a way to detect whether a table
> exists - just query the system tables using standard SQL. These can also be used to detect existing fields in tables.
No problems, that is what I was doing anyway - I just had trouble believing Firebird could not do this, and had the feeling I was going down the wrong path.