1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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)

Question Posted / elumalai.k


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

What is the difference between Stored Procedures and triggers?

0 Answers   HCL,

What are the differences between char and varchar in ms sql server?

0 Answers  

What is shared lock?

0 Answers  

What is the advantage of specifying WITH GRANT OPTION in the GRANT command?

2 Answers  

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

2 Answers   HCL,




what are defaults? : Sql server database administration

0 Answers  

create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration

0 Answers  

Tell me extended events in sql server 2008?

0 Answers  

What types of Joins are possible with Sql Server?

0 Answers   NA,

how to select a field with firstletter as capital and remaining are small letters

11 Answers  

How to find the last update record in SQL Server?

4 Answers  

What is indexing a document?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories