db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ян Программист <webautoma...@gmail.com>
Subject Re: SHOW command in ij
Date Thu, 08 Apr 2010 14:48:05 GMT
Man, that's it! Thanks. Here you are:

ij> show indexes from restaurants;
TABLE_NAME          |COLUMN_NAME         |NON_U&|TYPE|ASC&|CARDINA&|PAGES
----------------------------------------------------------------------------


Выбрано строк: 0
ij> describe restaurants;
COLUMN_NAME
|TYPE_NAME|DEC&|NUM&|COLUM&|COLUMN_DEF|CHAR_OCTE&|IS_NULL&
------------------------------------------------------------------------------
ID                  |INTEGER  |0   |10  |10    |NULL      |NULL      |YES

NAME                |VARCHAR  |NULL|NULL|20    |NULL      |40        |YES

CITY                |VARCHAR  |NULL|NULL|50    |NULL      |100       |YES


DESCRIBE command is  what I needed. But I am a bit confused. COLUMN_DEF
appears to be NULL for all columns. ?! John

Mime
View raw message