Derby 쿼리 실행 - ij

> ij
ij> connect 'jdbc:derby://localhost:1527/testDerbyDB;create=true';

ij> show connections;
CONNECTION0* -  jdbc:derby://localhost:1527/data/airlinesDB
* = 현재 연결

ij> show schemas;
TABLE_SCHEM
------------------------------
APP
NULLID
SQLJ
SYS
SYSCAT
SYSCS_DIAG
SYSCS_UTIL
SYSFUN
SYSIBM
SYSPROC
SYSSTAT

11행이 선택되었습니다.

ij> show tables in app;
TABLE_SCHEM         |TABLE_NAME                    |REMARKS
------------------------------------------------------------------------
APP                 |CITIES                        |
APP                 |FLIGHTAVAILABILITY            |
APP                 |FLIGHTHISTORY                 |
APP                 |FLIGHTS                       |
APP                 |USERS                         |

5행이 선택되었습니다.

ij> run ....