Minh tao 2 table trong SQL SEVER:
CREATE TABLE A
(
MSA CHAR(2) NOT NULL,
TA VARCHAR(20) NOT NULL,
CONSTRAINT PK_A PRIMARY KEY(MSA)
)
CREATE TABLE B
(
MSB CHAR(2) NOT NULL,
TB VARCHAR(30) NOT NULL,
CONSTRAINT PK_B PRIMARY KEY(MSB),
CONSTRAINT FK_B_A FOREIGN KEY(MSA) REFERENCES A(MSA)
)
Thi khong tao duoc khoa ngoai MSA cua table B tham chieu len khoa chinh cua table A MSA
no bao loi nhu duoi day:
Foreign key 'FK_B_A' references invalid column 'MSA' in referencing table 'B'
ban nao giup minh voi
Tks!!!!!!!!!!!!!!!!!!!!!!!!
Bookmarks