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
- 6202 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
Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security
How self join is different from outer join?
Tell me what is the order in which the sql query is executed?
How to backup encryption key ?
What the different components of Replication and what is their use?
Why do you need a sql server?
Do you know spatial data types - geometry and geography in sql server 2008?
What is a rownum?
What is named query? : sql server analysis services, ssas
How to change the ownership of a schema in ms sql server?
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
What language is sql server written in?
What is the return type of executeupdate ()?
What are statistics?
what exactly sql injuction.how to overcome.....
