Clearing a Data Extension with a SQL Query

If you ever need an automated way to clear a data extension, you can simply use a SQL query that does an overwrite. The query doesn’t need a from clause if you specify any required columns in the target.

For example, if EmailAddress is required in the target data extension, simply set the value to null and add an alias:

(Visited 2,423 times, 4 visits today)
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments