how to change the table name

[Former Member]

hi

instead of copying and renaming

is there any other way to change the ztable name .

I have wrong named the table and activated now i need to

change the table table from ztest to zvk01

thanks

[Former Member]

It is not possible to rename the table name.. better way is to copy it into another and delete the original as you told...

[Former Member]

Hi,

If your the person who has created the table or was it created by some other person long back..

Now if the table does not contain any data in all the dev , testing and production

You can blindly copy the ztest to zvk01 .

Thats the only best option you have...

If you want to practice creating data base table you can simple delete ztest and create it again with a different name.

Satish Boguda

[Former Member]

Hi,

before deleting the old table, dont forget to copy the contents of the old table into new one.

Cheers

[naveen_kumar7]

these r the steps to change table name ..

goto se11 tcode.

give ur oldtable.

goto top of the se11 ->goto dictionary objects ->copy->

give from table name to table name .

And the copy of ur table will be new table name ..

And to delete oldtable name.

goto se80->goto ur package ->select datadictionary ->select the old table name ->rt click ->delete.

I think its some what useful.

[Former Member]

Hi,

i too think that that other than copying existing table to another one there is no other chance of changing table name

And i think that this is the best way to solve your issue

Simply copy and delete old table

Edited by: vardhancse on Jul 26, 2010 10:01 AM

[Former Member]

Hi,

You cant rename the tale name but you can directly copy.

thanks.