The actual difference between Delete and
Truncate Table
command for delete table is that
a) A
Truncate table
statement is executed much faster than delete table.
b)
Truncate table
does not support the where clause.
c)
Truncate Table
Statement does not fire a trigger. When truncate is used, the deleted rows are not entered in the transaction log.
d) You can also not use
Truncate Table
statement for delete table which is referenced by Foreign key constraint.
and it depends upon query which is better between
Delete
and
Truncate Table
Command. if you want to delete all table means not want to use selected value from table then in that case
Truncate Table
will be the best
For more details navigate the given link
difference between DELETE and TRUNCATE[
^]
Hope it will works for you.