Pregunta de entrevista de Systech

difference between truncate and delete?

Respuesta de la entrevista

Anónimo

16 feb 2017

If we use truncate it deletes all the rows of the table in a single shot and the structure remains If we delete with where condition it delete the particular rows which we mention and without where condition it acts as truncate