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 do I install only the client tools of sql server 2000?

1 Answers  

Can you explain some of the DTS problems?

1 Answers   UBS, Wipro,

What happens if strings are casted into wrong code pages in ms sql server?

1 Answers  

What are rows and columns?

1 Answers  

How can a user-defined datatype be created?

1 Answers  

What is indexing explain it with an example?

1 Answers  

Is sql server difficult to learn?

1 Answers  

How to concatenate two binary strings together?

1 Answers  

What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?

1 Answers  

What is Schema? and why we use schemas?

4 Answers  

What are the magic tables in SQL Server 2000?

7 Answers   Infogain, Merrill Lynch,

Explain what you mean by 3 tier architecture.

1 Answers   TCS,

For more SQL Server Interview Questions Click Here
Categories