Rename a Database Table without loosing its data.
I want to rename a database table without loosing its data content.
I have searched a coulpe of blgs and could not find any thing helpful.
I have gone thru this page,
and then thought there must be some way, if you read point 3,
- By converting the table (see
Conversion Process). The database table is renamed and serves as a temporary buffer for the data. The revised version of the table is activated in the ABAP Dictionary and created in the database. The data is reloaded from the temporary buffer to the new database table (with MOVE-CORRESPONDING) and the indexes on the table are built.
I am not sure, how to achieve this.
Will be great, if some one can kindly guide me..!!
Thanking You All..!!
It is not possible as you are changing name. Database utility SE14 will work only with same table.
May be you can search enhancement for copy option in SE11 where you can put code to copy data.