Skip to main content
S
sreev97350841
Level 2
May 16, 2019

Drop custom table

  • May 16, 2019
  • 1 reply
  • 4001 views

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

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    1 reply

    kapilKochar
    kapilKochar
    Level 6
    May 17, 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

    S
    sreev97350841Author
    Level 2
    May 18, 2019

    Thank you Kapil. That worked.

      Terms & ConditionsAccessibility statement

      Loading footer...