1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / shakeer

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

More SQL Server Interview Questions

How to disable triggers using "disable trigger"?

0 Answers  

What is the difference between for xml raw and for xml auto?

0 Answers  

How to Debug a Stored Procedure?

5 Answers   Allianz,

Define Unique Key?

0 Answers   HCL,

Can you create a logon trigger in sql server 2005 express edition?

0 Answers  




Hi Can any one tell me the Good institute to learn SQL esp for Data Base Testing or SQL from scratch to the proficiency level in Hyederabad and facult also. Thankyou well in advance

6 Answers  

How fixed length strings are truncated and padded?

0 Answers  

what is curser.

9 Answers  

Explain where clause?

0 Answers  

How can count the string ? for ex: If i have string like 'bhaskar' then i need like b:1 h:1 a:2 s:1 k:1 r:1 please give any idea on that

9 Answers   TCS,

How to download and install microsoft sql server management studio express?

0 Answers  

How to filter out duplications in the returning rows in ms sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories