Question d’entretien chez Zycus
SQL difference between truncate, drop and delete commands
Réponse à la question d'entretien
Utilisateur anonyme
27 août 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.