Skip to Content
Jul 13 at 01:34 AM

How to alter a not-empty custom table structure ?


We have a custom table Z001 which is not empty in production environment, Now I want to change a non-key column type from integer to float. So how to do that? What I think is 1. create another table Z002 2. transport all data in Z001 to Z002 3. empty Z001 4 alter z001.5.move data back from z002.

Is there a better solution? and if not, do I need to write a program to transport the table data or is there a Tcode for that ?Thx.