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
- 6219 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
what is the difference between a primary key and a unique key? : Sql server database administration
What is optimization and its types?
What is cursors?
What is the use of partition by in sql server?
Do you know the capabilities of cursors?
How you can get a list of all the table constraints in a database?
Can you leave a union at any time?
Explain sql delete command?
is there a column to which a default can't be bound? : Sql server database administration
What will be query used to get the list of triggers in a database?
What is xdr?
Explain triggers in sql?
What is 3nf normalization?
what's sql server? : Sql server database administration
What happens if null values are involved in boolean operations?
