cancel
Showing results for 
Search instead for 
Did you mean: 

Database column rename Java Dictionary

Former Member
0 Kudos

Hi,

currently I am trying to rename a database coumn using the NWDS. I now see in the logfile that the column I renamed is dropped and the added again.

This is not the way it should behave, I belive. Using the mechanism, all the data will be lost by a rename of a column. Is there a way to keep the data by a rename of the column?

Thanks and regards,

Sebastian

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

Through NWDS Java Dictionary if u try to rename a column all the data in the backend will surely be lost.

The operations that could be performed from NWDS is:

Add a column, Increase field length, Extend primary key, create and delete indexes, change table buffer settings.

Imagine renaming a column means just deleting the old one and replacing it with a new one.

So simply its not possible. This holds the same for operations like:

Delete columns, Decrease field length, rename column, change column type, set column as not null.

U can do this only if the table is empty.

- Nagarajan.

Former Member
0 Kudos

Hi Nagarajan,

thanks for answering. So there is no possibility to change a name of a database column without loosing the content?

Sebastian

Answers (1)

Answers (1)

Former Member
0 Kudos

You can adjust the table at database level with SQL statements if you want to keep the data.