Pergunta de entrevista da empresa Coforge

What is difference between delete and truncate in sql?

Respostas da entrevista

Sigiloso

23 de mar. de 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

Sigiloso

28 de mar. de 2022

Delete is used in dml where truncate is used in dcl