Why foreign key column allowing null values even a parent
tables reference key column not having null value..
Answer Posted / 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 View All Answers
What is the filtered index?
what are the different stages of Report Processing?
What are the different authentication modes in sql server?
What is difference between after and before?
What is #table in sql server?
What are relationships and mention different types of relationships in the dbms
how would you improve etl (extract, transform, load) throughput?
Is sql server 2016 free?
What is an etl file?
What is used to replicate sessions between instances in coldfusion clusters?
Define Wed Edition in SQL Azure?
what are the different types of replication you can set up in sql server? : Sql server database administration
Explain what are the restrictions that views have to follow? : SQL Server Architecture
Explain what is log shipping?
Explain what is scheduled job and how to create it?