Delete V/S Truncate

Both commands are used to remove data from tables but they have following differences: -

Note: - delete and truncate both can be roll backed if used with transaction.

Syntax of delete

delete from emp where id=1


Syntax of truncate

truncate table emp


Email Address

For any query you can send mail at