truncate deletes all data for good. it also reduces the size of the file holding the data on disk. delete marks the data as deleted . you can undo the command if used in a sql procedure drop deletes the data + the structure of the table.