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

Answer Posted / rajkumar

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

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How extra digits are handled with numeric data type literals?

519


Is it possible to have clustered index on separate drive from original table location?

509


How do I find the sql server database version?

523


Explain difference between control flow and data flow?

523


Explain what are the database objects? : SQL Server Architecture

557






Why Master database is required?

596


Why main is user defined function?

563


What is db stored procedure?

463


What are views used for?

614


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?

643


what are different types of raid configurations? : Sql server database administration

482


What do you mean by normalisation?

496


What are parameterized reports? What are cascading parameters in ssrs reports?

100


How to list all schemas in a database?

569


How to execute a stored procedure in ms sql server?

543