--- In firebird-support@yahoogroups.com, Peter Faulks <fbml@i...> wrote:

> On Sun, 13 Feb 2005 10:38:47 -0000
> "pukindog_2004" <pukindog_2004@y...> wrote:
>
> > How can I find if a particular table exists in the
> > database, or a particular column exists in a table?
>
> How about ISQL's SHOW TABLES and SHOW TABLE table
>
> Regards

Thanks Peter:

I remember SHOW TABLES from MySQL. I looked for
that statement in Firebird's documentation with no
luck.

Passing the SQL "SHOW TABLES" to Firebird results
in an error, "SHOW" is an unknown token.

Is "SHOW TABLES" a valid Firebird command? What
is its syntax?

Thanks
Larry