Use the Clear Table instruction to delete all of the data in a managed table. This step is usually added to processes where all the data is refreshed each run.
1. Add a new data manipulation step to your process.
2. In the new step, add an instruction and select "Clear Table". Hint: You can find the instruction by searching for it:
3. Link your managed table to the instruction:
4. Run the step. After it has completed successfully, open the managed table (that you linked) and confirm that it is now empty - showing 0 rows and 0KB of storage space:
Tips and Tricks:
You can achieve a similar outcome by checking the "clear old data?" box when importing data into your managed table (see step 10 in the following guide: link). This will ensure that all of the data from your managed table is removed before importing the new set of data.
One of the really important features of the Clear Table instruction is that it also clears the Transaction Log of the underlying SQL table. This can be very important for large data sets to ensure that your data storage does not build up over time.