Interested to Buy Any Domain ? << Click Here >> for more details...
Is it possible to allow NULL values in foreign key?
I s it possible to use different constraints for the same
column in the table
(i.e) (id int NOT NULL,UNIQUEUE)
- 1 Answers
- 9554 Views
- I also Faced
- E-Mail Answers
Answer Posted / uma
Yes, it is possible to allow NULL values in a foreign key,
this property has a relation with the another property "ON
UPDATE/DELETE SET NULL".
It is also possible to define multiple constraints on a
single column.
| Is This Answer Correct ? | 10 Yes | 4 No |
Post New Answer View All Answers
How to get nth highest salary from employee table.
What are the acid properties?
you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation
Why are sql functions used?
What is stored in the mssqlsystemresource database? : sql server database administration
What is an execution plan? How would you view the execution plan?
how would you troubleshoot blocking? : Sql server database administration
Which language is supported by sql server?
what purpose does the model database serve? : Sql server database administration
List all types of constraints in sql server?
What is model database? : SQL Server Architecture
Tell me about joins in database system and explain each in detail.
Explain what is the use of custom fields in report?
What are the different SQL Server Versions you have worked on?
What is the difference between clustered index and primary key?
