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
- 6106 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 happens when the SQL Azure database reaches Max Size?
What is the order by used for?
What does truncate do?
What are the advantages of having an index on the sql server?
What are extended events in sql server?
is it important for a database administrator to understand the operating system and file access? : Sql server administration
Mention the different types of triggers?
Is oracle faster than sql server?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
What is a trigger and types of a trigger?
What is the recovery model?
Create and insert into temp table in sql server?
What is database replication? What are the different types of replication you can set up in sql server?
Name few of the dcl commands in sql?
What is the difference between the 2 operating modes of database mirroring?
