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 is the difference between functions and stored procedures?

0 Answers   Accenture,

Explain timestamp datatype?

0 Answers  

your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration

0 Answers  

what type of indexes physically sort data?

3 Answers  

What are the different types of sub-queries?

0 Answers  

What is etl - extraction, transformation, and loading?

0 Answers  

What is the difference between for xml raw and for xml auto?

0 Answers  

Is it possible we can connect our SQL database to GUI application? If it is yes than how tell me the explanation

2 Answers  

What is the maximum size of column in sql server?

0 Answers  

how to know description of a table in sqlserver 2000

8 Answers  

How will u find the query which is running in some other machine

4 Answers   CarrizalSoft Technologies, IBM,

How do I create an extended event in sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories