Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Drop custom table

Avatar

Avatar
Validate 1
Level 2
sreev97350841
Level 2

Likes

8 likes

Total Posts

13 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 2
sreev97350841
Level 2

Likes

8 likes

Total Posts

13 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
View profile
sreev97350841
Level 2

16-05-2019

Hello,

We are new to Adobe Campaign Classic and have a question on the database schema. We created a custom stand alone table which we want to drop. How can I drop the custom table using the "Update database structure" wizard?

Thanks

Sree

Replies

Avatar

Avatar
Validate 1
MVP
kapilKochar
MVP

Likes

128 likes

Total Posts

140 posts

Correct Reply

43 solutions
Top badges earned
Validate 1
Contributor
Give Back 10
Give Back 5
Give Back 3
View profile

Avatar
Validate 1
MVP
kapilKochar
MVP

Likes

128 likes

Total Posts

140 posts

Correct Reply

43 solutions
Top badges earned
Validate 1
Contributor
Give Back 10
Give Back 5
Give Back 3
View profile
kapilKochar
MVP

16-05-2019

Hi Sree,

Update database structure wizard only work to insert/delete  data of table . You will not be able to drop the table itself by using update database structure wizard.

To drop the table please use SQL Code activity under Actions tab and use

DROP TABLE <tableName>

P.S : Make sure you deleting your own table  and never use this to delete any OOB tables. 

Thanks,

Kapil Kochar

Avatar

Avatar
Validate 1
Level 2
sreev97350841
Level 2

Likes

8 likes

Total Posts

13 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 2
sreev97350841
Level 2

Likes

8 likes

Total Posts

13 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
View profile
sreev97350841
Level 2

17-05-2019

Thank you Kapil. That worked.