This works with Oracle.

Do you have read perms for that table?  Please run the following SQL command

   SELECT * FROM scheme.TABLE WHERE 1 = 2;

(use your schema and table name, of course).  What happens?


Sebastian Kloska wrote:

 Btw
 I checked out SqlTool on Sybase Anywhere 7.x.
 Bails out when issuing

 \d scheme.TABLE

 i.e when trying to access tables not owned
 by the current user

 with

 "Syntax error near 'WHERE'"

 Cheers

S.,

-- ICF: 703-934-3692 Cell: 703-944-9317



-------------------------------------------------------
This SF.Net email is sponsored by the new InstallShield X.
From Windows to Linux, servers to mobile, InstallShield X is the
one installation-authoring solution that does it all. Learn more and
evaluate today! http://www.installshield.com/Dev2Dev/0504
_______________________________________________
hsqldb-developers mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/hsqldb-developers

Reply via email to