Can a primary key be a foreign key in the same table? Say, in emp table empid is the primary key. Then can we have a column mgrid which will be a foreign key of the same emp table referencing empid?
No Comments Posted for this Article.
How does a primary key work in a table dictionary.
The concept of NUMBER RANGES in Abap data dictionary is same as we create sequence in Oracle . Sometimes it is required to directly access individual records in a data structure. This is done with...
Difference between Primary key and Unique Key
What is the difference between Primary key and Unique Key ?Primary exists in database table while unique key exists in internal tables. We can perform actions like sorting, searching, modifying...
What is foreign key relationship?
A relationship which can be defined between tables and must be explicitly defined at field level. Foreign keys are used to ensure the consistency of data. Data entered should be checked against...