difference between truncate and delete?
Anonimo
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