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 difference between foreign key and reference key

Answer Posted / anup

very simple...we use primary key or foreign key whenever we need to make relation.ex..if we need to join student (Roll P.K) and marks(roll F.K.) then we can join both tables only if we have primary key in one table and foreign key in other..one table may have n numbers of foreign key and n number of primary key (Called composite key)..mail me if u need more details in oracle or any front end lang...anup from chennai,Ranchi.

Is This Answer Correct ?    8 Yes 27 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can I introduce multiple conditions in like operator?

981


How to commit the current transaction in oracle?

1104


How can we find out the duplicate values in an oracle table?

1035


What is translate in oracle?

1089


Calculate difference between 2 date / times in oracle sql?

1036


Can a parameter be passed to a cursor?

1111


what is the scenario where you take the database to NoArchivelog mode?

2318


How to assign query results to variables?

1043


How to start your 10g xe server?

1030


How to invoke the original export import utilities?

1050


How to use fetch statement in a loop?

1014


Will you be able to store pictures in the database?explain.

988


What are named parameters?

1085


How to execute a stored procedure in oracle?

1075


What are the arithmetic operations?

1074