Interested to Buy Any Domain ? << Click Here >> for more details...
What primary key and foreign key relationship
- 1 Answers
- 3595 Views
- Infosys, I also Faced
- E-Mail Answers
Answer Posted / harish
the primary key defines the uniqueness of the table.
Let's take the example.MARA..the unique key or the primary key is MATERIAL number.So you cannot have two records of the same material number..the primary key is used to avoid duplicates..
By setting a foreign key brings a relation between two tables..
Let's take the example..VBAP-MATNR it has got the foreign key to the table MARA...so that you cannot enter a value which is not in the table MARA.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are logical databases?
Performance tuning techniques
Static and instance variable and method with live example. Why and when to use
How do we assign dynamic views while creating material master and generating bdc? : abap bdc
What are the differences between primary and secondary indexes?
Explain the different types of mode (run code) in call transaction method?
Explain what is step-loop? Explain all the steps?
How to load data from ms excel sheet to sap by using bdc method ? : abap bdc
What is the difference between sum and collect?
Example of table cluster and cluster tables.
On ABAP, Did you set up a workflow? Are you familiar with all steps for setting up a workflow?
what is the t-code to link technical and functional operation?
What is the difference between RETURNING and CHANGING parameters for a method?
If a table that is to be extended contains a long field, we cannot use append structures why? : abap data dictionary
Explain difference between primary key and unique key?
