Zycus interview question
SQL difference between truncate, drop and delete commands
Interview Answer
Anonymous
27 Aug 2020
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.