Domanda di colloquio di Celebal Technologies

Difference between delete ,truncate and drop?

Risposta di colloquio

Anonimo

11 nov 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.