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 an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration

0 Answers  

How to run sql server 2005 books online on your local system?

0 Answers  

How do you Implement SSIS Packages in your Project?

0 Answers  

What are cursors?

8 Answers  

How many types of cursor type are there?

0 Answers  

What are transactions in sql?

0 Answers  

Please explain go command in sql server?

0 Answers  

How can we get count of the number of records in a table?

0 Answers  

What are the steps you should follow to start sql server in single-user mode?

0 Answers  

Where are SQL server users names and passwords are stored in sql server?

0 Answers   HCL,

How to create prepared statements using odbc_prepare()?

0 Answers  

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

0 Answers   HCL, Wipro,

For more SQL Server Interview Questions Click Here
Categories