What is difference between delete and truncate in sql?
Réponses aux questions d'entretien
Utilisateur anonyme
28 mars 2022
Delete is used in dml where truncate is used in dcl
Utilisateur anonyme
23 mars 2025
Answer
delete is used to delete a specific row we can use where clause and is a type of dml whereas truncate is used when we need to completely delete all rows in table and is type of ddl