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

Does Firebird recognize "SHOW TABLES"? What is
its syntax?

Thanks
Larry