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)



Is it possible to allow NULL values in foreign key? I s it possible to use different constraints fo..

Answer / 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

More SQL Server Interview Questions

Which institute is best for SQL Server 2005 Training?

6 Answers  


What is the command used to check locks in microsoft sql server?

0 Answers  


How are the exceptions handled in sql server programming?

0 Answers  


wat new abt truncate in sql server

2 Answers   HCL, HP,


An employee table, with the columns id, name, sal and dob. Query to select emp names of all highest salaries(there are 4-5 people having the same salary which happens to be the highest).

9 Answers   ADP,






Can group by and orderby be used together?

0 Answers  


hi, i have a table called names and field name select * from names name a b c d i want to display like this name a,b,c,d how it is possible Regards Baiju

4 Answers  


What is difference between restoration and recovery in SQLServer?

3 Answers   Microsoft,


What is the use of placing primary key and foreign key constrains on columns.

4 Answers   Value Labs,


What is difference between process and thread? Explain lazy writer funcationality.

2 Answers   Microsoft,


Do you know what is sql injection?

0 Answers  


What is GUID in sql server?

0 Answers   BirlaSoft,


Categories