Pergunta de entrevista da empresa Celebal Technologies

Difference between delete ,truncate and drop?

Resposta da entrevista

Sigiloso

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.