Why foreign key column allowing null values even a parent
tables reference key column not having null value..
- 2 Answers
- 5628 Views
- IBM, I also Faced
- E-Mail Answers
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
How to execute multiple stored procedures at one time in sql server?
How many ways to create table-valued functions?
How to add the custom code in Report?
What are the main sources of data?
What is public role in sql server?
How do I view a stored procedure in sql server?
What is sql server 2000 work load governor?
What is the purpose of sql profiler in sql server? : sql server database administration
How can we improve performance by using SQL Server profiler?
What are the different kinds of ssrs reports?
How to declare and use cursor variables?
What is SQL Azure Fabric?
How to apply filtering criteria at group level with the having clause in ms sql server?
How to create a new schema in a database?
Why people hate cursor?
