Pergunta de entrevista da empresa Systech

difference between truncate and delete?

Resposta da entrevista

Sigiloso

16 de fev. de 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