Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Rename a Database Table without loosing its data.

Hi All,

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,

Adjusting Database Structures - Database Utility - SAP Library

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..!!

Former Member
Former Member replied

Hi Ankit,

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.

Regards,

Sid

1 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question