Systech interview question
difference between truncate and delete?
Interview Answer
Anonymous
Feb 16, 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