What is difference between truncate and delete?

Delete is a DML command whereas truncate is DDL command. ... Truncate can be used to delete the entire data of the table without maintaining the integrity of the table. On the other hand , delete statement can be used for deleting the specific data.

Related posts: