Subject | Re: [ib-support] SHOW TABLES; error code -104 token unknown SHOW |
---|---|
Author | Helen Borrie |
Post date | 2003-03-02T01:00:14Z |
At 09:22 PM 1/03/2003 +0000, you wrote:
heLen
>I'm trying toSHOW <object[s]> is an ISQL token - it's not available in DSQL.
>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?
heLen