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
Answer / rajkumar
Foreign key consider only the values. According to null value is not a value.
Is This Answer Correct ? | 1 Yes | 0 No |
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 |
Explain indexed views?
Define magic tables in sql server?
How to connect ms access to sql servers through odbc?
What are system databases in ms sql server?
What are indexes? When do you need to create Indexes?
4 Answers CarrizalSoft Technologies, HP,
What is transaction server implicit?
What is normalization in Database ?
What methods do you follow to protect from sql injection attack?
What are the parts of a function?
How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?
Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication
What do you understand by intent locks?