01-04-2019 3:39 PM
Hello,
I created a table in se11. I added entries to the table but after some time i changed a field name. So to activate the table i go to database utility and activate it with option persist data.
But strangely the data in the field becomes null after the change.
The table fields are provided in below screenshot
I make the changes to the field emp_address to EMP_ADDRESS1. The new output from se16 is below.
Can anyone tell why this is happening?
01-04-2019 4:16 PM
Strange ? No I don't think so. You removed EMP_ADDRESS and added EMP_ADDRESS1. The DB Utility recognises fields by name when saving data, not by position so since EMP_ADDRESS1 is not the same as EMP_ADDRESS your data was not preserved.
Rich
01-04-2019 4:16 PM
Strange ? No I don't think so. You removed EMP_ADDRESS and added EMP_ADDRESS1. The DB Utility recognises fields by name when saving data, not by position so since EMP_ADDRESS1 is not the same as EMP_ADDRESS your data was not preserved.
Rich
01-06-2019 12:30 PM
01-06-2019 5:25 AM
thanks Richard.
So it is an expected behaviour.
Is there a way to keep the data as it is and change the column name?
01-06-2019 12:13 PM
Richard gives you the correct answer ==> you should have choose his answer as the best answer
01-06-2019 12:23 PM
01-06-2019 3:58 PM