Hello Larry,

p> I remember SHOW TABLES from MySQL. I looked for
p> that statement in Firebird's documentation with no
p> luck.
It's not FB statement, it's isql command.

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

p> Is "SHOW TABLES" a valid Firebird command? What
p> is its syntax?
You cannot use it in FB SQL, since it's isql command: isql interprets
that command as requests to system tables like the ones, which are
described in the another reply to this thread. Refer to OpGuide.pdf
(IB6 doc) to find out about the commands isql processes.


HTH
--
Best regards,
Pavel Menshchikov
http://www.ls-software.com