I never used ISQL, but these two commands only works in
interactive mode in it - not on normal SQL.

On Sun, 13 Feb 2005 23:22:39 -0000, pukindog_2004 wrote:

>
>
>--- 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
>
>
>
>
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>