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

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

Explain indexed views?

0 Answers  


Define magic tables in sql server?

0 Answers  


How to connect ms access to sql servers through odbc?

0 Answers  


What are system databases in ms sql server?

0 Answers  


What are indexes? When do you need to create Indexes?

4 Answers   CarrizalSoft Technologies, HP,






What is transaction server implicit?

0 Answers  


What is normalization in Database ?

4 Answers  


What methods do you follow to protect from sql injection attack?

0 Answers  


What are the parts of a function?

0 Answers  


How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?

3 Answers  


Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication

0 Answers  


What do you understand by intent locks?

0 Answers  


Categories