I tried to use SHOW, but had following bug:
ij> show tables;
TABLE_SCHEM |TABLE_NAME |REMARKS
------------------------------------------------------------------------
SYS |SYSALIASES |
SYS |SYSCHECKS |
SYS |SYSCOLPERMS |
SYS |SYSCOLUMNS |
SYS |SYSCONGLOMERATES |
SYS |SYSCONSTRAINTS |
SYS |SYSDEPENDS |
SYS |SYSFILES |
SYS |SYSFOREIGNKEYS |
SYS |SYSKEYS |
SYS |SYSROLES |
SYS |SYSROUTINEPERMS |
SYS |SYSSCHEMAS |
SYS |SYSSTATEMENTS |
SYS |SYSSTATISTICS |
SYS |SYSTABLEPERMS |
SYS |SYSTABLES |
SYS |SYSTRIGGERS |
SYS |SYSVIEWS |
SYSIBM |SYSDUMMY1 |
APP |RESTAURANTS |
Выбрано строк: 21
ij> show indexes in RESTAURANTS;
ОШИБКА IJ: Не существует таблицы с именем null
ij> show indexes in restaurants;
ОШИБКА IJ: Не существует таблицы с именем null
Any suggestions? I haven't understood - is there no equivalent to EXPLAIN in
SQL syntax of Derby?!
About DERBY-3973. Here are my results:
....
CREATE TRIGGER TRIG2 AFTER DELETE ON FLIGHTS FOR EACH STATEMENT
INSERT INTO FLIGHTS_HISTORY (STATUS) VALUES ('INSERTED FROM TRIG2');
COMMIT;
Вставлено/обновлено/удалено строк: 0
ij> > > Вставлено/обновлено/удалено строк: 0
ij> ij> > > > > > > Вставлено/обновлено/удалено строк: 0
ij> > > Вставлено/обновлено/удалено строк: 0
ij> > > Вставлено/обновлено/удалено строк: 0
ij> > > Вставлено/обновлено/удалено строк: 0
ij> ij> > > > > > > > > > Вставлено/обновлено/удалено строк: 0
ij> > > Вставлено/обновлено/удалено строк: 0
ij> > > > > Вставлено/обновлено/удалено строк: 0
ij> ij> > > > > > > > > > > > > > Вставлено/обновлено/удалено строк: 0
ij> > Вставлено/обновлено/удалено строк: 0
ij> > Вставлено/обновлено/удалено строк: 0
ij> > > > Вставлено/обновлено/удалено строк: 0
ij> > > Вставлено/обновлено/удалено строк: 0
ij> ij> > > > > > > > > > Вставлено/обновлено/удалено строк: 0
ij> > > > > Вставлено/обновлено/удалено строк: 0
ij> > > > > > > Вставлено/обновлено/удалено строк: 0
ij> ij> > > > > > > > > > > Вставлено/обновлено/удалено строк: 0
ij> ij> > > > > > > > > > > > > > > Вставлено/обновлено/удалено строк: 0
ij> ij> > Вставлено/обновлено/удалено строк: 0
ij> > Вставлено/обновлено/удалено строк: 0
ij> select t.table_schem, t.table_name, c.column_name, c.type_name from
table( getTables( null, '%', '%' ) ) t, table( getColumns( null, '%', '%',
'%') ) c where c.table_schem = t.table_schem and c.table_name = t.table_name
and t.table_type = 'TABLE'
ij> > ;
TABLE_SCHEM
|TABLE_NAME
|COLUMN_NAME
|TYPE_NAME
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
APP
|AIRLINES
|AIRLINE
|CHAR
APP
|AIRLINES
|AIRLINE_FULL
|VARCHAR
APP
|AIRLINES
|BASIC_RATE
|DOUBLE
APP
|AIRLINES
|DISTANCE_DISCOUNT
|DOUBLE
APP
|AIRLINES
|BUSINESS_LEVEL_FACTOR
|DOUBLE
APP
|AIRLINES
|FIRSTCLASS_LEVEL_FACTOR
|DOUBLE
APP
|AIRLINES
|ECONOMY_SEATS
|INTEGER
APP
|AIRLINES
|BUSINESS_SEATS
|INTEGER
APP
|AIRLINES
|FIRSTCLASS_SEATS
|INTEGER
APP
|CITIES
|CITY_ID
|INTEGER
APP
|CITIES
|CITY_NAME
|VARCHAR
APP
|CITIES
|COUNTRY
|VARCHAR
APP
|CITIES
|AIRPORT
|VARCHAR
APP
|CITIES
|LANGUAGE
|VARCHAR
APP
|CITIES
|COUNTRY_ISO_CODE
|CHAR
APP
|COUNTRIES
|COUNTRY
|VARCHAR
APP
|COUNTRIES
|COUNTRY_ISO_CODE
|CHAR
APP
|COUNTRIES
|REGION
|VARCHAR
APP
|FLIGHTAVAILABILITY
|FLIGHT_ID
|CHAR
APP
|FLIGHTAVAILABILITY
|SEGMENT_NUMBER
|INTEGER
APP
|FLIGHTAVAILABILITY
|FLIGHT_DATE
|DATE
APP
|FLIGHTAVAILABILITY
|ECONOMY_SEATS_TAKEN
|INTEGER
APP
|FLIGHTAVAILABILITY
|BUSINESS_SEATS_TAKEN
|INTEGER
APP
|FLIGHTAVAILABILITY
|FIRSTCLASS_SEATS_TAKEN
|INTEGER
APP
|FLIGHTS
|FLIGHT_ID
|CHAR
APP
|FLIGHTS
|SEGMENT_NUMBER
|INTEGER
APP
|FLIGHTS
|ORIG_AIRPORT
|CHAR
APP
|FLIGHTS
|DEPART_TIME
|TIME
APP
|FLIGHTS
|DEST_AIRPORT
|CHAR
APP
|FLIGHTS
|ARRIVE_TIME
|TIME
APP
|FLIGHTS
|MEAL
|CHAR
APP
|FLIGHTS
|FLYING_TIME
|DOUBLE
APP
|FLIGHTS
|MILES
|INTEGER
APP
|FLIGHTS
|AIRCRAFT
|VARCHAR
APP
|FLIGHTS_HISTORY
|FLIGHT_ID
|CHAR
APP
|FLIGHTS_HISTORY
|SEGMENT_NUMBER
|INTEGER
APP
|FLIGHTS_HISTORY
|ORIG_AIRPORT
|CHAR
APP
|FLIGHTS_HISTORY
|DEPART_TIME
|TIME
APP
|FLIGHTS_HISTORY
|DEST_AIRPORT
|CHAR
APP
|FLIGHTS_HISTORY
|ARRIVE_TIME
|TIME
APP
|FLIGHTS_HISTORY
|MEAL
|CHAR
APP
|FLIGHTS_HISTORY
|FLYING_TIME
|DOUBLE
APP
|FLIGHTS_HISTORY
|MILES
|INTEGER
APP
|FLIGHTS_HISTORY
|AIRCRAFT
|VARCHAR
APP
|FLIGHTS_HISTORY
|STATUS
|VARCHAR
APP
|MAPS
|AREA
|DECIMAL
APP
|MAPS
|REGION
|VARCHAR
APP
|MAPS
|MAP_NAME
|VARCHAR
APP
|MAPS
|MAP_ID
|INTEGER
APP
|MAPS
|PHOTO_FORMAT
|VARCHAR
APP
|MAPS
|PICTURE
|BLOB
John
