{"id":4427,"date":"2022-06-03T11:42:11","date_gmt":"2022-06-03T11:42:11","guid":{"rendered":"https:\/\/www.wikitechy.com\/interview-questions\/?p=4427"},"modified":"2022-06-03T11:42:11","modified_gmt":"2022-06-03T11:42:11","slug":"difference-between-delete-and-truncate","status":"publish","type":"post","link":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/difference-between-delete-and-truncate\/","title":{"rendered":"Difference between Delete and Truncate"},"content":{"rendered":"

\"\"<\/p>\n

\u00a0<\/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>\nUsed 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

\u00a0<\/td>\n

Truncate command deletes complete row from\u00a0 a table.<\/p>\n

\u00a0<\/td>\n<\/tr>\n

We can roll back the delete commands.<\/p>\n

\u00a0<\/td>\n

We cannot roll back the truncate commands.<\/p>\n

\u00a0<\/td>\n<\/tr>\n

Delete command is very slow because it maintains a log<\/p>\n

\u00a0<\/td>\n

That\u2019s why it is fast. This command is very fast as it does not maintain any log<\/p>\n

\u00a0<\/td>\n<\/tr>\n

It uses row lock when performing delete function<\/p>\n

\u00a0<\/td>\n

Truncate command uses table log while performing the truncate function<\/p>\n

\u00a0<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"

\u00a0 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. \u00a0 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":{"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":"\nDifference between Delete and Truncate - Delete vs Truncate Command<\/title>\n<meta name=\"description\" content=\"Difference between Delete and Truncate - Used to delete rows from a table based on the condition provided on the where clause.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/difference-between-delete-and-truncate\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Difference between Delete and Truncate - Delete vs Truncate Command\" \/>\n<meta property=\"og:description\" content=\"Difference between Delete and Truncate - Used to delete rows from a table based on the condition provided on the where clause.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/difference-between-delete-and-truncate\/\" \/>\n<meta property=\"og:site_name\" content=\"Wikitechy\" \/>\n<meta property=\"article:published_time\" content=\"2022-06-03T11:42:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/05\/what-is-the-difference-between-delete-and-truncate.jpg\" \/>\n<meta name=\"author\" content=\"webmaster\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"webmaster\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/difference-between-delete-and-truncate\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/difference-between-delete-and-truncate\\\/\"},\"author\":{\"name\":\"webmaster\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#\\\/schema\\\/person\\\/f785ba3ecc599133e65ab6138042a3e4\"},\"headline\":\"Difference between Delete and Truncate\",\"datePublished\":\"2022-06-03T11:42:11+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/difference-between-delete-and-truncate\\\/\"},\"wordCount\":132,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/difference-between-delete-and-truncate\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/what-is-the-difference-between-delete-and-truncate.jpg\",\"keywords\":[\"delete vs truncate vs drop in sql\",\"difference between delete and drop\",\"Difference between DELETE and TRUNCATE\",\"Difference between Delete and Truncate Command\",\"difference between delete and truncate in oracle\",\"Difference between Delete and truncate in sql query\",\"difference between delete drop and truncate\",\"Difference between TRUNCATE and DELETE in SQL\",\"Differences between Delete and Truncate in SQL Server\",\"truncate command in sql\",\"What is the main difference between delete and TRUNCATE in SQL\",\"why truncate is faster than delete\"],\"articleSection\":[\"DBMS\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/difference-between-delete-and-truncate\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/difference-between-delete-and-truncate\\\/\",\"url\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/difference-between-delete-and-truncate\\\/\",\"name\":\"Difference between Delete and Truncate - Delete vs Truncate Command\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/difference-between-delete-and-truncate\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/difference-between-delete-and-truncate\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/what-is-the-difference-between-delete-and-truncate.jpg\",\"datePublished\":\"2022-06-03T11:42:11+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#\\\/schema\\\/person\\\/f785ba3ecc599133e65ab6138042a3e4\"},\"description\":\"Difference between Delete and Truncate - Used to delete rows from a table based on the condition provided on the where clause.\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/difference-between-delete-and-truncate\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/difference-between-delete-and-truncate\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/what-is-the-difference-between-delete-and-truncate.jpg\",\"contentUrl\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/what-is-the-difference-between-delete-and-truncate.jpg\",\"width\":558,\"height\":441},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#website\",\"url\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/\",\"name\":\"Wikitechy\",\"description\":\"Interview Questions\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#\\\/schema\\\/person\\\/f785ba3ecc599133e65ab6138042a3e4\",\"name\":\"webmaster\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/155b77fd8cdda3d0913fcb7e7ee63543b0c345d2d8f6dcebda5b0583ab61f967?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/155b77fd8cdda3d0913fcb7e7ee63543b0c345d2d8f6dcebda5b0583ab61f967?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/155b77fd8cdda3d0913fcb7e7ee63543b0c345d2d8f6dcebda5b0583ab61f967?s=96&d=mm&r=g\",\"caption\":\"webmaster\"},\"sameAs\":[\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\"],\"url\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/author\\\/webmaster\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Difference between Delete and Truncate - Delete vs Truncate Command","description":"Difference between Delete and Truncate - Used to delete rows from a table based on the condition provided on the where clause.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/difference-between-delete-and-truncate\/","og_locale":"en_US","og_type":"article","og_title":"Difference between Delete and Truncate - Delete vs Truncate Command","og_description":"Difference between Delete and Truncate - Used to delete rows from a table based on the condition provided on the where clause.","og_url":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/difference-between-delete-and-truncate\/","og_site_name":"Wikitechy","article_published_time":"2022-06-03T11:42:11+00:00","og_image":[{"url":"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/05\/what-is-the-difference-between-delete-and-truncate.jpg","type":"","width":"","height":""}],"author":"webmaster","twitter_card":"summary_large_image","twitter_misc":{"Written by":"webmaster","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/difference-between-delete-and-truncate\/#article","isPartOf":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/difference-between-delete-and-truncate\/"},"author":{"name":"webmaster","@id":"https:\/\/www.wikitechy.com\/interview-questions\/#\/schema\/person\/f785ba3ecc599133e65ab6138042a3e4"},"headline":"Difference between Delete and Truncate","datePublished":"2022-06-03T11:42:11+00:00","mainEntityOfPage":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/difference-between-delete-and-truncate\/"},"wordCount":132,"commentCount":0,"image":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/difference-between-delete-and-truncate\/#primaryimage"},"thumbnailUrl":"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/05\/what-is-the-difference-between-delete-and-truncate.jpg","keywords":["delete vs truncate vs drop in sql","difference between delete and drop","Difference between DELETE and TRUNCATE","Difference between Delete and Truncate Command","difference between delete and truncate in oracle","Difference between Delete and truncate in sql query","difference between delete drop and truncate","Difference between TRUNCATE and DELETE in SQL","Differences between Delete and Truncate in SQL Server","truncate command in sql","What is the main difference between delete and TRUNCATE in SQL","why truncate is faster than delete"],"articleSection":["DBMS"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.wikitechy.com\/interview-questions\/dbms\/difference-between-delete-and-truncate\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/difference-between-delete-and-truncate\/","url":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/difference-between-delete-and-truncate\/","name":"Difference between Delete and Truncate - Delete vs Truncate Command","isPartOf":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/difference-between-delete-and-truncate\/#primaryimage"},"image":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/difference-between-delete-and-truncate\/#primaryimage"},"thumbnailUrl":"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/05\/what-is-the-difference-between-delete-and-truncate.jpg","datePublished":"2022-06-03T11:42:11+00:00","author":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/#\/schema\/person\/f785ba3ecc599133e65ab6138042a3e4"},"description":"Difference between Delete and Truncate - Used to delete rows from a table based on the condition provided on the where clause.","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wikitechy.com\/interview-questions\/dbms\/difference-between-delete-and-truncate\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/difference-between-delete-and-truncate\/#primaryimage","url":"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/05\/what-is-the-difference-between-delete-and-truncate.jpg","contentUrl":"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/05\/what-is-the-difference-between-delete-and-truncate.jpg","width":558,"height":441},{"@type":"WebSite","@id":"https:\/\/www.wikitechy.com\/interview-questions\/#website","url":"https:\/\/www.wikitechy.com\/interview-questions\/","name":"Wikitechy","description":"Interview Questions","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.wikitechy.com\/interview-questions\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.wikitechy.com\/interview-questions\/#\/schema\/person\/f785ba3ecc599133e65ab6138042a3e4","name":"webmaster","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/155b77fd8cdda3d0913fcb7e7ee63543b0c345d2d8f6dcebda5b0583ab61f967?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/155b77fd8cdda3d0913fcb7e7ee63543b0c345d2d8f6dcebda5b0583ab61f967?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/155b77fd8cdda3d0913fcb7e7ee63543b0c345d2d8f6dcebda5b0583ab61f967?s=96&d=mm&r=g","caption":"webmaster"},"sameAs":["https:\/\/www.wikitechy.com\/interview-questions"],"url":"https:\/\/www.wikitechy.com\/interview-questions\/author\/webmaster\/"}]}},"_links":{"self":[{"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts\/4427","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/comments?post=4427"}],"version-history":[{"count":2,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts\/4427\/revisions"}],"predecessor-version":[{"id":4452,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts\/4427\/revisions\/4452"}],"wp:attachment":[{"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/media?parent=4427"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/categories?post=4427"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/tags?post=4427"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}