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

List out a number of the wants to setup a SQL Server failover cluster?

0 Answers  

syntax for deleting the database in T SQL

5 Answers  

write a query to remove duplicate records without using primary key column?

2 Answers   ABCO,

Can you please explain the difference between function and stored procedure?

0 Answers  

What is the difference between value type and reference type?

0 Answers  

What is the maximum rows in sql server table?

0 Answers  

what are different types of raid configurations? : Sql server database administration

0 Answers  

how would you troubleshoot blocking? : Sql server database administration

0 Answers  

How will u get 5 years back record?

5 Answers  

What is the best way to move n number of DTS package from one SQLServer to another SQLServer?

1 Answers   RBS,

How can you tell if a database object is invalid?

0 Answers   MCN Solutions,

What is update locks?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories