Subject Re: How to determine if table exists.
Author wgonzaless
--- In, "David Frischknect"
<fishnet37222@...> wrote:
> Hello,
> I'm using Firebird as an embedded database in an application I'm
> developing. The application is going to create the database
> programmatically at startup if it doesn't already exist. Is there a
> way to determine if a table exists in the database? I'd also like to
> know if there's a way I can pass the contents of a text-file to be
> executed by the engine. Much thanks.
> --
> David A. Frischknecht

David, use this:

select rdb$relation_name from rdb$relations
where (rdb$relation_name = 'TABLE_NAME')
and (rdb$system_flag=0);

William GS