Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

write the query for taking database backup in sql

10 Answers   ABC, IBM, Logica CMG, MA,

What are the purposes of floor and sign functions?

0 Answers  

How get current date in SQL server 2000

4 Answers   Cap Gemini, Polaris,

what is index seek and index scan?

2 Answers  

What is the bookmark lookup and rid lookup?

0 Answers  

What factors you will consider calculating the storage requirement for that view?

0 Answers  

Do you know hot add cpu in sql server 2008?

0 Answers  

How would you retrieve Unique rows from table without using UNIQUE and DISTINCT keyword?

2 Answers   Genpact,

What is the template in sql?

0 Answers  

Why use view instead of a table?

0 Answers  

What is the new security features added in sql server 2014? : sql server security

0 Answers  

What is Trace flag?

1 Answers   Wipro,

For more SQL Server Interview Questions Click Here
Categories