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 difference between group by and having?

0 Answers  

Explain the third normal form(3nf)?

0 Answers  

Give an example of SQL injection attack ?

0 Answers   HAL,

Explain the types of indexes.

0 Answers   Accenture,

what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration

0 Answers  




What are the components of sql server service broker?

0 Answers  

How to drop an existing user defined function in ms sql server?

0 Answers  

How to create logins using windows Authentication mode?

2 Answers  

you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration

0 Answers  

What is a stored procedure?

3 Answers  

What is 3nf normalization?

0 Answers  

How to list all login names on the ms sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories