Correction:
If successful COLUMN0 = 1 and if not succesful then no row returned at all.

Mike

----- Original Message -----
From: "M Tuttle (KS)" <miket@...>
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@...>
> 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
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >
> >
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>