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

What is the use of placing primary key and foreign key
constrains on columns.

Question Posted / durga prasad

Answers were Sorted based on User's Feedback



What is the use of placing primary key and foreign key constrains on columns...

Answer / monal

TO CREATE REFERENTIAL INTEGRITY BETWEEN 2 TABLE.

Is This Answer Correct ?    3 Yes 0 No

What is the use of placing primary key and foreign key constrains on columns...

Answer / jagadeesh b

If you maintain this relation ship you can get more advantages

1)you can not delete primary table directly..

2)duplicate values are not allowed in primary key table.

3)Null values are not inserted into primary key table so
validation is very easy fro m front end.(for ex; .net 2005).




Is This Answer Correct ?    3 Yes 0 No

What is the use of placing primary key and foreign key constrains on columns...

Answer / deepak

1) PRIMARY KEY IS USED AS UNIQUE KEY, FOR AVOID DUPLICATION.
2) FOR VALIDATING DATA FROM PRIMARY KEY TABLE FOREIGN KEY USE.

Is This Answer Correct ?    1 Yes 0 No

What is the use of placing primary key and foreign key constrains on columns...

Answer / rajendraprasad cherukuri

To segregate the data in different tables belongs to a
particular entity so that data can be retrieved when
required more economically and in a faster way.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

Can store procedure call by user define function in SQL server?

10 Answers   HCL,

What is function of CUBE ?

0 Answers   HCL,

What are the steps to process a single select statement?

0 Answers  

What is sqlcmd?

0 Answers  

Can the query output be sorted by multiple columns in ms sql server?

0 Answers  

what is differencial backup?how to work?Anybody explai it?

2 Answers   HCL,

How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?

3 Answers  

What is the sql case statement used for? Explain with an example?

0 Answers  

What is difference between sql and sql server?

0 Answers  

How to replace given values with null using nullif()?

0 Answers  

Advantages and Disadvantages of Cursor?

15 Answers   Polytechnic, TCS, Zenith,

What is a Lock and let me know Different types of locks?

2 Answers  

For more SQL Server Interview Questions Click Here
Categories