Pregunta de entrevista de Celebal Technologies

Difference between delete ,truncate and drop?

Respuesta de la entrevista

Anónimo

11 de nov de 2023

Ans-Delete is used to delete a single record or multiple records depending upon the condition specify in the where clause ->Drop is used to delete the whole database or table. ->Truncate is used to delete the data inside the table not the whole table.