-- Databricks notebook source -- MAGIC %md -- MAGIC ##### Truncate and Delete -- MAGIC - Delta tables support DML operations such as Insert, Delete, Merge -- MAGIC - CSV table do not support Delete ...

Differences Between : DELETE, TRUNCATE and DROP in SQL Server DELETE Command: Type of Command - DELETE is a DML (Data Manipulation Language) command. Purpose - Deletes specific rows based on ...