Question d’entretien chez Systech

difference between truncate and delete?

Réponse à la question d'entretien

Utilisateur anonyme

16 févr. 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