Application Development 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: 

Renaming custom table

Former Member
0 Kudos

Is it possible to rename a custom table or do i need to copy it to a new table and delete the existing one?

Thanks in advance

Prem

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Hi,

You can copy the existing table and thus re-name the new table. But during this process, Please take care of the following:

1.) new table maintenace has to be generated for the (re-named) table.

2.) Table maintenance events of the existing table will get removed. So, you may have introduce these events in the new table (Re-named one).

3.) If you had introduced POV for any of the fields in the PAI of table maintenace screen, then that logic has to be copied into the newly generated table maintenance.

Regards,

Rajesh

5 REPLIES 5

Former Member
0 Kudos

Hi Prem,

you don't have another option.

just you need to copy to another table with desired name and delete the original.

Thanks!

Former Member
0 Kudos

Hi,

You can copy the existing table and thus re-name the new table. But during this process, Please take care of the following:

1.) new table maintenace has to be generated for the (re-named) table.

2.) Table maintenance events of the existing table will get removed. So, you may have introduce these events in the new table (Re-named one).

3.) If you had introduced POV for any of the fields in the PAI of table maintenace screen, then that logic has to be copied into the newly generated table maintenance.

Regards,

Rajesh

Former Member
0 Kudos

Hi ,

you can't rename an existing custom table. Instead you can copy t he existing table to a new one and delete the original.

regards

Gowri

Former Member
0 Kudos

Dear,

it is not possible to rename an existing database table instead you can copy from an existing one if you do so then you need to regenerate table maintenance generator .

Cheers

fareed

0 Kudos

Hi

Renaming a custom table can be done only by copying it to another table.In se11 u will have the copy option.By clicking on that we can give destination table name.But here again u have to regenerate table maintanence genarator.

Regards.