Application Development 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: 

Is it possible to rename a table?

vinod_vemuru2
Active Contributor
0 Kudos

Hi Guys,

Is it possible to rename a table in data dictionary as we did for reports? If no then Is there any theory behind this concept?

Usefull answers will be rewarded.

Thanks,

Vinod.

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Hi

u cannot rename a table in data dictionary....we can only change the description.....

u can copy the table and then give the required name....

10 REPLIES 10

Former Member
0 Kudos

Hi

u cannot rename a table in data dictionary....we can only change the description.....

u can copy the table and then give the required name....

Former Member
0 Kudos

Hi,

Copy it to a new one and then delete the old one.

copying the table will give u a name. However, SAP has not provided the renaming functionality since in SAP terms, both are same.

theres no way to rename the existing table.

regards

preet

reward if helpful

Former Member
0 Kudos

hi,

u cant rename a table instead u can change the description.

if u want to change the table name only then copy the table which provides u an option of giving the table name again.

reward if found helpful,

Former Member
0 Kudos

hi,

its not possible to rename a table in dictionary as once its stored. this is because dictionary is client independent and once a table is stored in it ,it has its own existence. If one tries to change its name the entire tables existence will be lost.

mayank

0 Kudos

hi,

one more thing dictionary can be updated but it cannot be edited.

you can add and delete in dictionary but you cannot change the attributes of dictionary elements.they are non editable.

plz reward points if found useful

thanks

mayank

Former Member
0 Kudos

Hi vinoth,

SAP Tool is not used in Rename menu for database name.

Reward if useful..

Rgts,

S.Suresh.

prasanth_kasturi
Active Contributor
0 Kudos

You cannot rename a table. if it is a must duplicate it and rename it as required

vinod_vemuru2
Active Contributor
0 Kudos

Thank u guys

Pramanan
Active Participant
0 Kudos

hi,

Try this one to Rename the Table Name

RENAME TABLE statement Locate the document in its SAP Library structure

A RENAME TABLE statement changes the name of a base table (see Table).

Syntax

<rename_table_statement> ::=

RENAME TABLE <old_table_name> TO <new_table_name>

<old_table_name> ::= <table_name>

<new_table_name> ::= <identifier>

table_name, identifier

Explanation

The old table name must identify a base table that is not a temporary table. The current user must be the owner of the table.

The new table name must not already be assigned to a base or view table or a private synonym of the current user.

The old table is assigned the name specified in the new_table_name. All of the properties of the table (e.g. privileges, indexes) remain unchanged. The definitions of view tables based on the old table name are adapted to the new name.

Leaving content frame

Former Member
0 Kudos

Hi,

It is not possible to rename a table , but one simple way delete it and create an another one .

Regards,

Muneesh Gitta.