What is the difference between DELETE and TRUNCATE statement in SQL? - Site Owners Forums

Pavan Techn · 06-01-2018, 10:16 AM

The main differences between SQL DELETE and TRUNCATE statements are given below:

No. DELETE TRUNCATE
1) DELETE is a DML command. TRUNCATE is a DDL command.
2) We can use WHERE clause in DELETE command. We cannot use WHERE clause with TRUNCATE
3) DELETE statement is used to delete a row from a table TRUNCATE statement is used to remove all the rows from a table.
4) DELETE is slower than TRUNCATE statement. TRUNCATE statement is faster than DELETE statement.
5) You can rollback data after using DELETE statement. It is not possible to rollback after using TRUNCATE statement.

Kumkum · 03-13-2021, 07:07 AM

This is very helpful information, thanks for it.
I have also learn other SQL statements from here.

06-01-2018, 10:16 AM	#1
Pavan Techn Registered User Join Date: Mar 2018 Posts: 341	What is the difference between DELETE and TRUNCATE statement in SQL? The main differences between SQL DELETE and TRUNCATE statements are given below: No. DELETE TRUNCATE 1) DELETE is a DML command. TRUNCATE is a DDL command. 2) We can use WHERE clause in DELETE command. We cannot use WHERE clause with TRUNCATE 3) DELETE statement is used to delete a row from a table TRUNCATE statement is used to remove all the rows from a table. 4) DELETE is slower than TRUNCATE statement. TRUNCATE statement is faster than DELETE statement. 5) You can rollback data after using DELETE statement. It is not possible to rollback after using TRUNCATE statement. __________________ Bulk SMS services provider in Coimbatore\|Software Development Company in Coimbatore\|Web design company in Coimbatore \|erp Crm software in coimbatore

03-13-2021, 07:07 AM	#2
Kumkum Registered User Join Date: Dec 2017 Posts: 43	This is very helpful information, thanks for it. I have also learn other SQL statements from here.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)