Skip to Content
avatar image
Former Member

Renaming custom table

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    May 11, 2009 at 06: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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 11, 2009 at 08: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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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.

  • avatar image
    Former Member
    May 11, 2009 at 06: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!

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 11, 2009 at 07: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

    Add comment
    10|10000 characters needed characters exceeded