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

What are the steps you will take to improve the performance of a poor performing query?

0 Answers  

in tabase table having a column in it empname field is there which having 5 duplicate values is there i want deleted all the duplicates i want showing only one name only.

7 Answers  

What is the diff between Dynamic queries and static queries

1 Answers   CGG, ICS Integrated Computer Solutions,

What is Sqlpaging in SqlServer 2005 ?

0 Answers   MCN Solutions,

How to return the date part only from a sql server datetime datatype?

0 Answers  

What are the tool windows in sql server management studio? : sql server management studio

0 Answers  

Explain the advantages of merge replication?

0 Answers  

Explain candidate key, alternate key, and composite key?

0 Answers  

What are indexers?

0 Answers  

How to create a trigger for insert only?

0 Answers  

you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration

0 Answers  

How do I clean up sql server transaction log?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories