How to Truncate a table? | Community
Skip to main content
H
hugol_vallejo
Level 2
August 11, 2020
Solved

How to Truncate a table?

  • August 11, 2020
  • 1 reply
  • 5468 views

Hi everyone

 

I am trying to truncate the contents of a custom table in the Adobe Campaign database. I created that table to hold a set of data that is imported on a daily basis from an external file,but I need to truncate it before loading the data set.

 

I know I could use the Update activity to delete records, but that requires an input. I could build that input by querying all data in the target table first and pass it to the Update activity, then the Update activity would delete the records from the incoming population. However, it would be much more efficient to just truncate the full table.

 

Can someone provide guidance on how to do it?

 

Cheers

Hugo

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

Hi @hugol_vallejo

To truncate the table please use SQL Code activity under Actions tab and use command:

TRUNCATE TABLE <tableName>

Regards,

Milan

1 reply

Milan_Vucetic
Milan_VuceticAccepted solution
Level 9
August 11, 2020

Hi @hugol_vallejo

To truncate the table please use SQL Code activity under Actions tab and use command:

TRUNCATE TABLE <tableName>

Regards,

Milan

    A
    AnkitaV3131
    Level 2
    June 7, 2023

    Hi Milan,

     

    I am currently facing an issue while attempting to truncate a table in Campaign V8. Despite trying various approaches such as using the table label, internal name, and the name provided in the documentation tab of the data schema, I consistently encounter an error indicating that the table does not exist. Interestingly, in my previous project, the same command worked flawlessly in Campaign V7.Whether there have been any changes to the command syntax or functionality in Campaign V8 that could be causing this issue. 

    Need your guidance and assistance on this and looking forward to your prompt response.

     

     

    Regards,

    Ankita

    Milan_Vucetic
    Milan_Vucetic
    Level 9
    June 22, 2023

    Hi @ankitav3131 

    Adobe v7 (if we talk about on-premise solution) you had previously could be on different database. Adobe v8 natively should work with PostgreSQL as primary base and Snowflake as secondary base. If your data model is not extended and if you not storing data on Snowflake I would suggest that you explore syntax for PostgreSQL. 
    Could it be that you already dropped the table but just schema remained?

      Terms & ConditionsAccessibility statement

      Loading footer...