topic Re: Rename Database table name in Application Development and Automation Discussions

Rename Database table name

Former Member — Mon, 05 Jan 2009 07:28:51 GMT

Hi All,

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

Thank All

Sal

Re: Rename Database table name

Former Member — Mon, 05 Jan 2009 07:32:35 GMT

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

Re: Rename Database table name

GauthamV — Mon, 05 Jan 2009 07:34:29 GMT

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.

Re: Rename Database table name

Former Member — Mon, 05 Jan 2009 07:34:53 GMT

Hi,

Search in the link below :

http://help.sap.com/saphelp_nw04s/helpdata/en/e0/55c13b43557606e10000000a114084/frameset.htm

Thanks,

Nitesh Jain

Re: Rename Database table name

Former Member — Mon, 05 Jan 2009 07:35:04 GMT

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

Re: Rename Database table name

Former Member — Mon, 05 Jan 2009 07:39:45 GMT

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

Re: Rename Database table name

faisalatsap — Mon, 05 Jan 2009 07:42:47 GMT

hi,

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

Kind Regards,

Faisal

Re: Rename Database table name

Former Member — Mon, 05 Jan 2009 08:25:03 GMT

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.

Re: Rename Database table name

Former Member — Mon, 05 Jan 2009 08:51:58 GMT

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.

Re: Rename Database table name

Former Member — Wed, 17 Mar 2010 07:57:40 GMT

This message was moderated.