大家好,我用的interbase数据库,表建好了,往表department输入内容时却出现这个错误,高手请教.-------------------------出错----------------------------------------------------master record missing violation of foreinge key constraint " manager " on "department"--------------------------------------------------------------------------------
我的department 表的结构如下
CREATE TABLE DEPARTMENT (
ID CHAR(3) NOT NULL,
NAME VARCHAR(20) NOT NULL,
MANAGER CHAR(6),
INTRO VARCHAR(4000)
)/* PrimaryKey DEPARTMENT_ID */
ALTER TABLE DEPARTMENT
ADD CONSTRAINT DEPARTMENT_ID
PRIMARY KEY (ID)/* ForeignKey MANAGER */
ALTER TABLE DEPARTMENT
ADD CONSTRAINT MANAGER
FOREIGN KEY (MANAGER)
REFERENCES PERSON
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货