Interested to Buy Any Domain ? << Click Here >> for more details...
Why foreign key column allowing null values even a parent
tables reference key column not having null value..
- 2 Answers
- 6129 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
Can we create clustered index on composite key?
Tell me what do you mean by an execution plan? Why is it used? How would you view it?
How to loop through returning rows?
what are the new features introduced in sql server 2000? : Sql server database administration
What is an index. What are the types?
What is dml command?
How to create a user name in a database?
How do I find information about the install locations for the various instances running on a computer?
What do you understand by SQL*Net?
What is difference between index and primary key?
Can we use where and having clause together?
What are types of storage modes? : sql server analysis services, ssas
When you should use a low fill factor?
what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
What is the default order of an order by clause?
