Difference between Truncate table and Delete Table

This blog will describe differences between delete table command and truncate table command

1)Delete Command

1)It supports where clause and hence it can be used to delete all rows from table or specified rows from table
2)It deletes row one by one
3)Delete commnad is DML command
4)When all rows are deleted from table using delete command then identity available on table will not be reset to its seed


2)Truncate Command

1)It doesnt supports where clause and hence it can be used to delete all rows from table
2)It deletes row page by page
3)Delete commnad is DDL command
4)When all rows are deleted from table using delete command then identity available on table will  be reset to its seed