Pregunta de entrevista de Capgemini

difference between delete, truncate and drop?

Respuesta de la entrevista

Anónimo

7 de jul de 2021

delete used to delete specific data, we can use with the where clause, delete can rollback the changes, delete the tabe row before deleting the row truncate used to delete entire data of the table, trucante can not used with where clause, truncate can't be rollback the changes, it is locks entire table Drop command is used to remove table definition & it's contents, drop command table space is free from memory,drop command viewof the table doesnot exits