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 info@techaltum.com
Thanks