Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Rename Database table name

Former Member
0 Likes
17,238

Hi All,

How do i rename a Z database table name ...?

Thank All

Sal

9 REPLIES 9
Read only

Former Member
0 Likes
5,588

Hi,

its not possible to rename your DB table name,

Better you copy the DB table with new table name.

and delete older once.

Thanks

Read only

GauthamV
Active Contributor
0 Likes
5,588

hi,

you can copy the table from SE11 transaction and then use SE14 to adjust database.

Before doing that check the where used list for that table and you have to modify

all those objects accordingly.

Read only

Former Member
0 Likes
5,588
Read only

Former Member
0 Likes
5,588

Hi,

We cannot rename a table in ABAP.You can only copy a table -> give a new name to the table and delete the previous one.

Regards

Vasavi

Read only

Former Member
0 Likes
5,588

Goto SE11 --> Enter Z table name --> Select Menu path Dictionary Object -> COPY.

give new table name. Save and Activate new table.

You may delete old table if not required.

Regards,

Mohaiyuddin

Read only

faisalatsap
Active Contributor
0 Likes
5,588

hi,

Be sure while Deleting DB Table and must have a look where it is being used,

Kind Regards,

Faisal

Read only

Former Member
0 Likes
5,588

Hi ,

I think that it is not possible to rename tables.

You can copy the table to a different name and use it accordingly.

Regards,

Radhika.

Read only

Former Member
0 Likes
5,588

Hi,

It is not possible to rename the database table. Its better to copy the database table with the new table and delete the previous one.

Copy the table from SE11, then SE14 to adjust the database.

Before doing that check the where used list for that table and you have to modify

all those objects accordingly.

Regards,

Jyothi CH.

Read only

Former Member
0 Likes
5,588

This message was moderated.