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

Why foreign key column allowing null values even a parent
tables reference key column not having null value..

Question Posted / shakeer

Answers were Sorted based on User's Feedback



Why foreign key column allowing null values even a parent tables reference key column not having n..

Answer / rajkumar

Foreign key consider only the values. According to null value is not a value.

Is This Answer Correct ?    1 Yes 0 No

Why foreign key column allowing null values even a parent tables reference key column not having n..

Answer / sureshramsing@gmail.com

Yes foreign key column allows null values, if it is not having either primary key or not null constraints.
Foreign key just reference to the particular parent column only not for restrcting the data while insert or update. It verifies dependency at the time of delete only.

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More SQL Server Interview Questions

What is outer join in sql server joins?

0 Answers  

How to rename an existing table with the "sp_rename" stored procedure in ms sql server?

0 Answers  

Difference between LEN() and DATALENGTH() in sql server ?

0 Answers   HCL,

What is the osql utility?

0 Answers  

What is de-normalization and when do you do it?

3 Answers  

Restore database SQL2000, SQL2012 Backup of base is created in Microsoft SQL Server 2000 - 8.00.2066, I can't restore on Microsoft SQL Server 2012 - 11.0.2100.60

3 Answers   IT Decisions,

How to query multiple tables jointly?

0 Answers  

What are the different types of backups that exist?

0 Answers   ADITI,

In which files does sql server actually store data?

0 Answers  

What are information schema views?

0 Answers  

Explain about SQL server 2005?

0 Answers  

how many triggers you can have on a table? : Sql server database administration

0 Answers  

For more SQL Server Interview Questions Click Here
Categories