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 <[EMAIL PROTECTED]>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. > >
