In sql we can delete all rows like:
DELETE FROM table_name
how can i do the same in marketing cloud by query for a data extension? I would like to delete all rows from a data extension.
List<sobject> g = new List<sobject>([Select id from table_name]); delete g;
sobject is your object name (make a list of the object)
I figured it out:
SELECT * FROM [DE_Name] WHERE 1 = 2