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

Renaming custom table

Former Member
0 Likes
4,441

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
Read only

Former Member
0 Likes
1,765

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
Read only

Former Member
0 Likes
1,765

Hi Prem,

you don't have another option.

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

Thanks!

Read only

Former Member
0 Likes
1,766

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

Read only

Former Member
0 Likes
1,765

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

Read only

Former Member
0 Likes
1,765

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

Read only

0 Likes
1,765

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.