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...
Solved! Go to Solution.
Topics help categorize Community content and increase your ability to discover relevant content.
Views
Replies
Total Likes
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.
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.
Hello @ogonzalesdiaz,
You can force the colomn sql name to the old sql name so that Adobe does not try to drop and recreate it like this :
<attribute label="Email 2.Informativo" name="EMAILINFORMATIVO" sqlname="semailrelacionalalertas" type="string"/>
Br,
Views
Replies
Total Likes
Views
Likes
Replies