Why foreign key column allowing null values even a parent tables reference key

Why foreign key column allowing null values even a parent
tables reference key column not having null value..

Question Posted / shakeer

2 Answers
5125 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Why foreign key column allowing null values even a parent tables reference key column not having n..

Answer / rajkumar

Foreign key consider only the values. According to null value is not a value.

Is This Answer Correct ?

1 Yes

0 No

Why foreign key column allowing null values even a parent tables reference key column not having n..

Answer / sureshramsing@gmail.com

Yes foreign key column allows null values, if it is not having either primary key or not null constraints.
Foreign key just reference to the particular parent column only not for restrcting the data while insert or update. It verifies dependency at the time of delete only.

Is This Answer Correct ?

1 Yes

1 No

Post New Answer