topic regarding table in Application Development and Automation Discussions

regarding table

Former Member — Tue, 06 Mar 2007 10:39:27 GMT

How can i rename the table(which is in active).plz tell me the step by step

thanks

Re: regarding table

Former Member — Tue, 06 Mar 2007 10:42:11 GMT

hi SKK,

try FM DB_RENAME_TABLE

regards,

santosh

Message was edited by:

Santosh Kumar Patha

Re: regarding table

Former Member — Tue, 06 Mar 2007 10:42:46 GMT

as there is no rename option You cannot rename a table, you can only copy it to another name and then delete the old one.

Re: regarding table

Former Member — Tue, 06 Mar 2007 10:43:43 GMT

Hi,

You can't rename the table like the Program of SE38.

You can only do a Copy.

Regards,

Anji

Re: regarding table

Former Member — Tue, 06 Mar 2007 10:48:39 GMT

Hi skk,

You might get one exception error:OLD_TABLE_DOES_NOT_EXIST when you use DB_RENAME_TABLE. In fact the old table exist in SAP DB. So it is better to copy that table to a new one and then give the name that you require.

Mark all helpful answers