C:\db2soft>db2 "select constname, tabname, refkeyname, reftabname, colcount, deleterule, updaterule from syscat.references where tabname='DEPARTMENT'"CONSTNAME ...
显示全部C:\db2soft>db2 "select constname, tabname, refkeyname, reftabname, colcount, del
eterule, updaterule from syscat.references where tabname='DEPARTMENT'"
CONSTNAME
TABNAME
REFKEYNAME
REFTABNAME
COLCOUNT DELETERULE UPDATERULE
--------------------------------------------------------------------------------
------------------------------------------------ -------------------------------
--------------------------------------------------------------------------------
----------------- --------------------------------------------------------------
------------------------------------------------------------------ -------------
--------------------------------------------------------------------------------
----------------------------------- -------- ---------- ----------
RDE
DEPARTMENT
PK_EMPLOYEE
EMPLOYEE
1 N A
ROD
DEPARTMENT
PK_DEPARTMENT
DEPARTMENT
1 C A
2 条记录已选择。
C:\db2soft> db2 "select constname, tabname, refkeyname, reftabname, colcount, de
leterule, updaterule from syscat.references where tabname='EMPLOYEE'"
CONSTNAME
TABNAME
REFKEYNAME
REFTABNAME
COLCOUNT DELETERULE UPDATERULE
--------------------------------------------------------------------------------
------------------------------------------------ -------------------------------
--------------------------------------------------------------------------------
----------------- --------------------------------------------------------------
------------------------------------------------------------------ -------------
--------------------------------------------------------------------------------
----------------------------------- -------- ---------- ----------
RED
EMPLOYEE
PK_DEPARTMENT
DEPARTMENT
1 N A
1 条记录已选择。
C:\db2soft>
搞明白了,去掉employee表那个指向department的外键,再set intdetity,最后再加上外键。搞了半天啊。
收起