Delete Data and Append Output tool (SQL Server Destination)

[akadwa]

Does the "Delete Data and Append" option in an output tool execute a "TRUNCATE" command or "DELETE...FROM" against the SQL server table? The reason I ask is because the TRUNCATE command is much more efficient than DELETE. 

[alexnajm · Accepted solution]

This article indicates a Truncate: Solved: Options in Output tool - Alteryx Community

[alexnajm]

Plus this one: Write Data In-DB - Delete Data & Append - Single T... - Alteryx Community