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

What are click through reports?

118


Explain trigger and its types?

801


What is the maximum size of a dimension? : sql server analysis services, ssas

774


What is the sql case statement used for?

759


What is shrink log file?

655


What is the main purpose of having conversation group?

667


Define outer join?

750


What is the difference between drop table and truncate table?

659


What is transaction server implicit?

691


When you use @@error and try-catch?

764


What are the advantages of sql azure?

134


A trigger can reference objects outside the current database? State true or false.

745


What is simple indexing method?

756


Differentiate between truncate vs delete in mssql?

688


What are the encryption mechanisms in sql server?

737