--- In firebird-support@yahoogroups.com, "M Tuttle \(KS\)"
<miket@s...> wrote:

> Correction:
> If successful COLUMN0 = 1 and if not succesful then no row returned

at all.

>
> Mike
>
> ----- Original Message -----
> From: "M Tuttle (KS)" <miket@s...>
> To: <firebird-support@yahoogroups.com>
> Sent: Sunday, February 13, 2005 7:33 AM
> Subject: Re: [firebird-support] Does This Table, or Column, Exist?
>
>
> >
> > Greetings Larry,
> >
> > You simply query the system tables.
> >
> > For Tables something like this:.
> > SELECT 1 FROM RDB$RELATIONS WHERE RDB$RELATION_NAME = 'ACCOUNT'
> >
> > For Fields something like this:
> > SELECT 1 FROM RDB$RELATION_FIELDS WHERE RDB$RELATION_NAME =

'ACCOUNT' AND

> > RDB$FIELD_NAME = 'ACCT_ID'
> >
> > If successful COLUMN0 = 1 and if not succesful then COLUMN0 = 0
> >
> > Mike
> >
> > ----- Original Message -----
> > From: "pukindog_2004" <pukindog_2004@y...>
> > To: <firebird-support@yahoogroups.com>
> > Sent: Sunday, February 13, 2005 4:38 AM
> > Subject: [firebird-support] Does This Table, or Column, Exist?
> >
> >
> > >
> > >
> > >
> > > Hi Folks:
> > >
> > > How can I find if a particular table exists in the
> > > database, or a particular column exists in a table?
> > >
> > > Thanks
> > > Larry

Thanks Mike:

Testing for a table that currently exists in the
database.

Open the database, start a transaction, Prepare()
this statement and pass it to Execute():

SELECT
1
FROM
RDB$RELATIONS
WHERE RDB$RELATION_NAME = 'nr_phrase_table_01'

Execute() returns without throwing an exception.

"nr_phrase_table_01" is the name of a table in
the database. A Fetch() returns 0.

I would expect Fetch to return non-zero if the
table exists in the database.

What am I doing wrong?

Thanks
Larry