My sequence and table rows are not in sync. When a new row is inserted I get a duplicate error because it returns a number which already exists. How can I solve this?
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...
How can we find Primary Key??????
Suppose there is a data field: XYZ in the table TAB. XYZ is a primary key and besides being primary key for the table TAB, this happens to be primary key for other tables as well. Now, is there any...
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...