Rename column without dropping column?

[ogonzalesdiaz]

I need to change this:

<attribute label="Email 2.Informativo" name="EMAILRELACIONALALERTAS" type="string"/>
to:

<attribute label="Email 2.Informativo" name="EMAILINFORMATIVO" type="string"/>

But  changing the "name" attribute and ACC wants to drop the whole column. ACC creates this SQL:

-- Log: Updating table 'NmsRecipient'
ALTER TABLE NmsRecipient
ADD COLUMN sEMAILINFORMATIVO VARCHAR(255),
ADD COLUMN sTELEFMOVILINFORMATIVO VARCHAR(255);
ANALYZE NmsRecipient;
ALTER TABLE NmsRecipient
DROP COLUMN semailrelacionalalertas,
DROP COLUMN stelefmovilmarketing;

I only need to change column name...

[_Manoj_Kumar_]

Hello @ogonzalesdiaz  I would suggest you to create the new column and the duplicate the data using combination of query and update data activity.

Once the data is in the new column then you can remove the old column.