05-11-2009 7:36 AM
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
05-11-2009 7:50 AM
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
05-11-2009 7:49 AM
Hi Prem,
you don't have another option.
just you need to copy to another table with desired name and delete the original.
Thanks!
05-11-2009 7:50 AM
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
05-11-2009 8:05 AM
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
05-11-2009 9:25 AM
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
05-11-2009 10:09 AM
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.