03-25-2008 6:32 AM
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.
03-25-2008 6:47 AM
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....
03-25-2008 6:47 AM
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....
03-25-2008 6:54 AM
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
03-25-2008 6:58 AM
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,
03-25-2008 7:07 AM
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
03-25-2008 7:12 AM
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
03-25-2008 10:08 AM
Hi vinoth,
SAP Tool is not used in Rename menu for database name.
Reward if useful..
Rgts,
S.Suresh.
03-25-2008 12:09 PM
You cannot rename a table. if it is a must duplicate it and rename it as required
04-16-2008 7:31 AM
04-16-2008 8:35 AM
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
04-16-2008 2:47 PM
Hi,
It is not possible to rename a table , but one simple way delete it and create an another one .
Regards,
Muneesh Gitta.