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
