topic Re: table rename in Application Development and Automation Discussions

table rename

Former Member — Mon, 08 Sep 2008 14:34:13 GMT

hi gurus....

how to rename a table?

Re: table rename

JozsefSzikszai — Mon, 08 Sep 2008 14:36:18 GMT

hi,

do you mean database table? No way... Only copy and delete the old one, but that will be another table, which means the data inside will be lost (you have to copy separately)

hope this helps

Re: table rename

Former Member — Mon, 08 Sep 2008 14:40:19 GMT

You cant rename a table .

Re: table rename

matt — Mon, 08 Sep 2008 16:48:16 GMT


> hi,
> 
> do you mean database table? No way... Only copy and delete the old one, but that will be another table, which means the data inside will be lost (you have to copy separately)
> 
> hope this helps
> ec

Surely that is a way, rather a "no way". Copy the table. Write a program to copy data from one to the other. Delete the data from the first table. Delete the table.

job done

Re: table rename

Former Member — Mon, 08 Sep 2008 16:52:46 GMT

hi!

we can't rename a table after creating it

Re: table rename

matt — Mon, 08 Sep 2008 16:57:02 GMT


> hi!
> 
>   we can't rename a table after creating it

Yes you can. See my post above.

Re: table rename

Former Member — Mon, 08 Sep 2008 18:36:03 GMT

> Matthew Billingham wrote:

> > prasanth kumar wrote:

> > hi!

> >

> > we can't rename a table after creating it

> Yes you can. See my post above.

Though that is strictly speaking "copy" and not "rename".

I know of a few places in SAP where one can "rename" data in certain key fields of tables. It's always a messy business I think.

@ Diane: In addition to Yes and No, is there also a 3rd option on the interview answer sheet called Hopefully not ?

Re: table rename

matt — Tue, 09 Sep 2008 08:03:55 GMT

Ah but... "renames" are usually implemented as "copy/deletes" anyway!

Re: table rename

shadow — Tue, 09 Sep 2008 09:03:30 GMT

Hi diana,

if it is predefine table? No way ,Only copy and delete the old one, but that will be another table, which means the data inside will be lost (you have to copy separately)

With Regard's

shaik.

Re: table rename

Former Member — Tue, 09 Sep 2008 14:10:36 GMT


> Hi diana,
>  
> if it is predefine  table? No way ,Only copy and delete the old one, but that will be another table, which means the data inside will be lost (you have to copy separately)
> 
>
> With Regard's
> shaik.

You liked Eric's answer so much that you wanted it to become your own as well?

Perhaps you should rather have posted something like:

> Damn... I wish I had said that...

???

Julius

Re: table rename

Former Member — Wed, 10 Sep 2008 11:11:38 GMT

hi,

its not possible to rename a table but you can copy the the table with your requried name.

Re: table rename

Former Member — Thu, 11 Sep 2008 07:47:44 GMT

Two days hence the question been asked. I think this reply has the most value-addtion.

Re: table rename

Former Member — Mon, 15 Sep 2008 10:28:04 GMT

Hi,

Do like this.

1.Go to se11 and copy the table zemp to zemp111.

2.Run the below report:

TABLES:

zemp,zemp111.

*SELECT **

FROM zemp

INTO zemp.

zemp111 = zemp.

INSERT zemp111 FROM zemp111.

delete zemp.

ENDSELECT.

Note:Now you will get the data from zemp to zemp111.

3.Delete the the table zemp.

4.Activate the zemp11 and see the table entries.

Hope this helps you.

Regards,

Rama.

Re: table rename

matt — Mon, 15 Sep 2008 11:51:28 GMT

Ah, but what if the table contains a 100 million rows? SELECT... ENDSELECT won't work then - you'll run out of memory.

Re: table rename

Former Member — Mon, 06 Oct 2008 05:38:52 GMT

Hi Diana,

here is your answer,

If the table is standard one, we cant change the name of the table, but if the table is user defined table we can easily change the name of the table by following the below procedure,

GOTO SE11 -> now type the table name in database

table field -> click dictionary obj from the menu bar -> now a new window will opens asking us to give a new name for our table -> type the name and then save it .

thus our table was renamed.

regards,

manju

Re: table rename

Former Member — Mon, 06 Oct 2008 06:05:04 GMT

hi,

if standard table then one can't rename or delete it....

if ztable then to rename it ,copy the contents of the table to be renamed to a new ztable and delete the old one .....

i think this is the only option.....

Re: table rename

Former Member — Mon, 06 Oct 2008 09:24:31 GMT

Hi Diana

Rename of Table is not possible...

you can make a copy of table with new name.

go to SE11

---in Database table option- give table name

and copy[option on the toolbar].... here u can give ur new name.

--- go inside ur new table and activate table.

Hope it willl help u!!!!!!!!!!!!

Regards,

Aparna

Re: table rename

Former Member — Mon, 06 Oct 2008 12:44:45 GMT

Hi Diane,

the fastest way: create a view on the table with the new name.

well, it's not really renaming but it may be sufficeint for some cases.

(i.e. I used the view to "rename" fields in a table to provide an interface layer

to a different application assuming slight different field names)

bye

Re: table rename

Former Member — Mon, 06 Oct 2008 12:55:51 GMT

Hi,

You can rename a Ztable...Use Txn SE14 (Database Utility) for the same.

Re: table rename

Former Member — Mon, 06 Oct 2008 13:16:13 GMT

thinking to rename a table is not a good idea.

even if you manage to rename a table, the programs which were using the table will dump