Why foreign key column allowing null values even a parent
tables reference key column not having null value..
Answer Posted / rajkumar
Foreign key consider only the values. According to null value is not a value.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
What is replication and database mirroring?
What is isnull() operator?
How many types of local tables are there in sql server?
Scalability, Availability, Integration with internet, etc.)?
What is the sql profiler?
Do you have any idea about the tcl commands?
Define left outer join in sql server joins?
What are database states in ms sql server?
Can we write trigger for view?
How to remove duplicate rows from table except one?
Are null values the same as that of zero or a blank space?
Does index slows down insert statements?
Can you explain about buffer cash and log cache in sql server?
Explain the first normal form(1nf)?