Frage im Vorstellungsgespräch bei Systech

difference between truncate and delete?

Antwort im Vorstellungsgespräch

Anonym

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