Adobe Campaign Classic - Dropping a column

Avatar

Avatar
Validate 1
Level 2
ankurm40172185
Level 2

Likes

15 likes

Total Posts

23 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 2
ankurm40172185
Level 2

Likes

15 likes

Total Posts

23 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
ankurm40172185
Level 2

26-02-2018

Hi

Are there any guidelines to follow if i want to drop a column in a custom table; or do we modify the xml and then propogate changes to the database and that is enough? What is the best way, or is there a best way?

I do not see anything on the campaign documentation on dropping columns.

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 1
MVP
Jean-Serge_Biro
MVP

Likes

353 likes

Total Posts

464 posts

Correct reply

153 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile

Avatar
Validate 1
MVP
Jean-Serge_Biro
MVP

Likes

353 likes

Total Posts

464 posts

Correct reply

153 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile
Jean-Serge_Biro
MVP

26-02-2018

Hi Ankurm,

If your schema leads the underlying SQL structure, yes, you can delete the element/attribute corresponding to the column in the schema, then propagate the change with Tools/Advanced/Update database structure:
Updating the database structure

But if you do the invert thing, that means, if the mapping is SQL-directed, you delete the column in the database engine, then you must use the other advanced tool Extend database to apply the change in your schema, or most often, do it manually (often easier if change is quite simple).

Please take care, because there could be indexes, or relationships based on the column to be deleted. And of course, data to be saved through a table backup is often a good recommendation.

Regards.
J-Serge

Answers (1)

Answers (1)

Avatar

Avatar
Validate 1
Level 2
ankurm40172185
Level 2

Likes

15 likes

Total Posts

23 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 2
ankurm40172185
Level 2

Likes

15 likes

Total Posts

23 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
ankurm40172185
Level 2

01-03-2018

Thanks Jean; I am glad that we did the right thing then. Its always a little worry if we are dropping things and not cleaning up properly.