0

Can I run DELETE query under Activity > Sql Query. I need to delete few records from data extension based on field values.

  • As @data_kid indicated, you cannot do in this in Salesforce directly. Datasert Realforce (we are the author) provides delete from object where blah syntax, which internally does the query and delete in multiple passes. – realfire Sep 13 '17 at 20:48
0

It is not possible to delete via query. What you can do is clone the de and exclude those values in the new target de

SELECT *

FROM [YourDE]

WHERE ColumnThatContainsRecords NOT IN (Value1, Value2,..... Valuen)
| improve this answer | |
  • If there are 1 million records in the DE, is this still a good solution if I need to run this query every day to delete few hundred records? @Data_Kid – sfdcFanBoy Mar 31 '18 at 4:21

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.