本文介绍了ALTER TABLE语句与FOREIGN KEY约束冲突的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我在尝试向我的 tblDomare
表中添加外键时遇到问题;我在这里做错了什么?
I have a problem when trying to add a foreign key to my tblDomare
table; what am I doing wrong here?
CREATE TABLE tblDomare
(PersNR VARCHAR (15) NOT NULL,
fNamn VARCHAR (15) NOT NULL,
eNamn VARCHAR (20) NOT NULL,
Erfarenhet VARCHAR (5),
PRIMARY KEY (PersNR));
INSERT INTO tblDomare (PersNR,fNamn,eNamn,Erfarenhet)
Values (6811034679,'Bengt','Carlberg',10);
INSERT INTO tblDomare (PersNR,fNamn,eNamn,Erfarenhet)
Values (7606091347,'Josefin','Backman',4);
INSERT INTO tblDomare (PersNR,fNamn,eNamn,Erfarenhet)
Values (8508284163,'Johanna','Backman',1);
CREATE TABLE tblBana
(BanNR VARCHAR (15) NOT NULL,
PRIMARY KEY (BanNR));
INSERT INTO tblBana (BanNR)
Values (1);
INSERT INTO tblBana (BanNR)
Values (2);
INSERT INTO tblBana (BanNR)
Values (3);
ALTER TABLE tblDomare
ADD FOREIGN KEY (PersNR)
REFERENCES tblBana(BanNR);
错误讯息:
推荐答案
发生这种情况是因为您尝试从 tblDomare.PersNR
到 tblBana.BanNR
创建一个外键,并且 tblDomare.PersNR
中的值与 tblBana.BanNR
中的任何值不匹配。您不能创建违反参照完整性的关系。
It occurred because you tried to create a foreign key from tblDomare.PersNR
to tblBana.BanNR
but/and the values in tblDomare.PersNR
didn't match with any of the values in tblBana.BanNR
. You cannot create a relation which violates referential integrity.
这篇关于ALTER TABLE语句与FOREIGN KEY约束冲突的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!