Drop custom table

[sreev97350841]

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

[kapilKochar]

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

[sreev97350841]

Thank you Kapil. That worked.