Subject Re: [ib-support] SHOW TABLES; error code -104 token unknown SHOW
Author Helen Borrie
At 09:22 PM 1/03/2003 +0000, you wrote:
>I'm trying to
>SHOW TABLES;
>using either IBAccess/ExecSQL or IBOConsole/InteractiveSQL,
>in Firebird 1.0.2-Win32.
>IBAccess says SQL error code -104 token unknown SHOW
>IBOConsole says nothing and shows nothing.
>I also tried
>SHOW TABLE GUEST (GUEST is my tablename)
>with similar results.
>Also tried UC and lc, with and without the ';'.
>
>As a sanity check, I tried
>SELECT * FROM GUEST
>and that works as expected in both, shows table data.
>The Interbase docs shows that 'SHOW' is a keyword, but apparently
>has no other reference to it.
>
>Is there some magic I need to do to SHOW TABLES?

SHOW <object[s]> is an ISQL token - it's not available in DSQL.

heLen