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...

what is the difference between primary key & foreign key?

Answer Posted / anand

Primary key is used to identify a row in a table and it
doesnot allow null values. It avoids duplication of rows.

whereas foreign key refers to a column or combination of
columns included in the defenition of referential integrity

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to create an oracle database?

1041


In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.

1935


How index is implemented in oracle database?

1006


Explain the use of record option in exp command.

1006


What are the tools for Oracle ?

1062


What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

1047


How to get execution statistics reports on query statements?

1094


How to drop a stored procedure in oracle?

1051


What is difference between cartesian join and cross join?

1088


How does Oracle guarantee data integrity of data changes?

2390


What do you mean by a tablespace?

1039


How will you differentiate between varchar & varchar2?

1044


What is ADDM Advisor in Oracle?

1178


How to get maxsal , minsal, ename department wise in single query

1549


How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

2180