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