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

How to delete an existing database user?

0 Answers  

How to find tables without indexes?

0 Answers  

Differnce between sel server 2000 and 2005

3 Answers  

how can u get last observation in an unknown dataset ?

0 Answers   Genpact,

What is dbcc? Give few examples.

0 Answers  

What is clustered index

0 Answers  

what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration

0 Answers  

Can we create nonclustered index in a table without creating a clustered index

1 Answers  

Do you know data definition language, data control language and data manipulation language?

0 Answers  

What is the default Port No on which SQL Server listens?

0 Answers  

About Indexed Views? with example? plz reply...

2 Answers  

How to swap the data of two columns in a table. both the columns containing varchar values.

9 Answers  

For more SQL Server Interview Questions Click Here
Categories