KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
create table EMP(Eid int primary key) insert into EMP values(11e3) --self referencing alter table EMP add constraint fk_EMP_Eid foreign key (Eid) references EMP(Eid) --now insert insert into EMP values(12e2) But, this insert should fail, because there is no previous value of Eid=1200 in the EMP table, so when the foreign key will reference this column , then it would not find the value, hence should fail the insert . but why does it succeeds?
Tags (comma-separated)
Save Edits
Cancel