--- In firebird-support@yahoogroups.com, "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