Subject | SHOW TABLES; error code -104 token unknown SHOW |
---|---|
Author | jwhinyyc <wexsessa@telusplanet.net> |
Post date | 2003-03-01T21:22:24Z |
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?
TIA
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?
TIA