- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
Hi Venur,
This question is more related to the underlying database engine (RDBMS) than Adobe Campaign itself.So take care and check carefull,
For most database engines (SQL Server, Oracle etc), alter table modify column instruction would loose data if the datatype is not in the same family, and a supersed.
For instance, short int to long int, ok but long int to short you could loose values by the casting. The same from varchar(100) to varchar(200), no problem.
And from very different types such as int, date, string, you would loose all data.
So take care and check carefully depending on source/destination types, if a simple alter is possible or not.
So if not the case, the directive is:
1. create a new column.
2. copy (insert casting-converting instruction(col2) select col1 SQL query) the current values of col1 casted/converted (using Convert, decode, and all the sql functions depending on your engine) into col2 column
3. suppress the col1 column.
Regards
J-Serge