on 12-28-2006 9:00 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can adjust the table at database level with SQL statements if you want to keep the data.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.