<\/p>\n

 <\/p>\n\n\n\n\n\n\n\n\n

\n Delete<\/strong><\/h4>\n<\/td>\n	\n Truncate<\/strong><\/h4>\n<\/td>\n<\/tr>\n
Used to delete rows from a table based on the condition provided on the where clause.<\/td>\n	Used to delete the entire data from rows from the table. Similar to delete command with no where clause<\/td>\n<\/tr>\n
\u00a0Delete commands deletes only the rows that are mentioned in where clause.<\/p>\n  <\/td>\n	Truncate command deletes complete row from\u00a0 a table.<\/p>\n  <\/td>\n<\/tr>\n
We can roll back the delete commands.<\/p>\n  <\/td>\n	We cannot roll back the truncate commands.<\/p>\n  <\/td>\n<\/tr>\n
Delete command is very slow because it maintains a log<\/p>\n  <\/td>\n	That’s why it is fast. This command is very fast as it does not maintain any log<\/p>\n  <\/td>\n<\/tr>\n
It uses row lock when performing delete function<\/p>\n  <\/td>\n	Truncate command uses table log while performing the truncate function<\/p>\n  <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n  <\/p>\n","protected":false},"excerpt":{"rendered":"   Delete Truncate Used to delete rows from a table based on the condition provided on the where clause. Used to delete the entire data from rows from the table. Similar to delete command with no where clause \u00a0Delete commands deletes only the rows that are mentioned in where clause.   Truncate command deletes complete […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"passster_activate_protection":false,"passster_protect_child_pages":"","passster_protection_type":"password","passster_password":"","passster_activate_overwrite_defaults":"","passster_headline":"","passster_instruction":"","passster_placeholder":"","passster_button":"","passster_id":"","passster_activate_misc_settings":"","passster_redirect_url":"","passster_hide":"no","passster_area_shortcode":"","gtb_hide_title":false,"gtb_wrap_title":false,"gtb_class_title":"","gtb_remove_headerfooter":false,"footnotes":""},"categories":[7157],"tags":[17460,17458,17456,17452,17462,17463,17461,17455,17464,17457,17453,17459],"class_list":["post-4427","post","type-post","status-publish","format-standard","hentry","category-dbms","tag-delete-vs-truncate-vs-drop-in-sql","tag-difference-between-delete-and-drop","tag-difference-between-delete-and-truncate","tag-difference-between-delete-and-truncate-command","tag-difference-between-delete-and-truncate-in-oracle","tag-difference-between-delete-and-truncate-in-sql-query","tag-difference-between-delete-drop-and-truncate","tag-difference-between-truncate-and-delete-in-sql","tag-differences-between-delete-and-truncate-in-sql-server","tag-truncate-command-in-sql","tag-what-is-the-main-difference-between-delete-and-truncate-in-sql","tag-why-truncate-is-faster-than-delete"],"yoast_head":"\n