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

HOW SHALL WE DIFFERENTIATE BETWEEN PRIMARY KEY AND FORIEGN
KEY?

Answer Posted / manoj byregowda

Primary key- A column (or columns)in a table which makes every row in table unique. eg - EMPLOYEE table, EMPID is column which is unique.

Foreign Key - A column (or columns) in table Whose value References to primary key of another table OR ( A column which derives its value from another tables primary key.)
eg - EMP table EMPID is PK and DEPTNO is FK.
DEPT table DEPTID is pk.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are different types of receipt reversals ? Explain them : oracle accounts receivable

1191


Is there any link between pr form(purchse requisition)and po form(purchase order)

2643


What is chargeback invoice? How do we create it? : oracle accounts receivable

1277


Difference between negative and positive adjustments : oracle accounts receivable

1009


i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks

2203


What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable

1003


Difference between transaction type and transaction sources. : oracle accounts receivable

975


how can we add a field to the oracle standard forms through Form Persanlization or custom.pll

2340


What is mrc and what is its use? : oracle accounts receivable

1093


HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?

2012


Are These Dff's Flexible?

1110


CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?

2009


difference of using cursor for loop and open,fetch,close.which one is better

1732


What are different types of transactions in ar? : oracle accounts receivable

1217


Differentiate between writeoff and receipt writeoff. : oracle accounts receivable

1256