I am using Derby 10.4.1.3

Using ij I can confirm that "show tables;"  and "describe <tablename>"; works  for example:

ij> show tables;
TABLE_SCHEM         |TABLE_NAME                    |REMARKS
------------------------------------------------------------------------
SYS                 |SYSALIASES                    |
SYS                 |SYSCHECKS                     |
SYS                 |SYSCOLPERMS                   |
SYS                 |SYSCOLUMNS                    |
SYS                 |SYSCONGLOMERATES              |
SYS                 |SYSCONSTRAINTS                |
SYS                 |SYSDEPENDS                    |
SYS                 |SYSFILES                      |



ij> describe sys.syscolumns;
COLUMN_NAME         |TYPE_NAME|DEC&|NUM&|COLUM&|COLUMN_DEF|CHAR_OCTE&|IS_NULL&
------------------------------------------------------------------------------
REFERENCEID         |CHAR     |NULL|NULL|36    |NULL      |72        |NO
COLUMNNAME          |VARCHAR  |NULL|NULL|128   |NULL      |256       |NO
COLUMNNUMBER        |INTEGER  |0   |10  |10    |NULL      |NULL      |NO
COLUMNDATATYPE      |org.apac&|NULL|NULL|-1    |NULL      |NULL      |NO
COLUMNDEFAULT       |java.io.&|NULL|NULL|-1    |NULL      |NULL      |YES
COLUMNDEFAULTID     |CHAR     |NULL|NULL|36    |NULL      |72        |YES
AUTOINCREMENTVALUE  |BIGINT   |0   |10  |19    |NULL      |NULL      |YES
AUTOINCREMENTSTART  |BIGINT   |0   |10  |19    |NULL      |NULL      |YES
AUTOINCREMENTINC    |BIGINT   |0   |10  |19    |NULL      |NULL      |YES

9 rows selected

Hope this helps.

B-)



On Fri, Aug 22, 2008 at 6:24 AM, munugalaramesh <ramesh.yem@gmail.com> wrote:

Dear All,

 Can any one help on this.

 I integrated ij tool with Eclipse (Europa) according to Apache Derby
documentation.

 I tried with the following commands,all of them are not working

 show tables;
describe tables;
show schemas;

 I am getting folowing error

ERROR 42X01: Syntax error: Encountered "describe" at line 1, column 1.

Advance thanks



--
View this message in context: http://www.nabble.com/Show-Tables-command-is-not-working-with-ij-Tool-tp19105443p19105443.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.