Domanda di colloquio di Systech

difference between truncate and delete?

Risposta di colloquio

Anonimo

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