Subject Re: How to determine if table exists.
Author Adam
--- 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?

If the database does not exist, there wont be any tables within it.
Using the embedded engine, the file must be locally accessible and you
must know the path (or can easily look it up in the aliases.conf you
have access too), so a simple File System file exists call will tell
you if that is there.

Is there any reason that you need to know if a table exists if you
know the database does exist?

www.fbtalk.net has a table exists query in the FAQ.

> 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.

What do you mean by text files being executed? Do you mean DDL scripts
to be applied to the database or do you mean you have some data in a
text file that you want to load into your table?

Adam