---
title: "Discussion on \"SQL - TRUNCATE VS DELETE DIFFERENCE\" | Hashnode"
description: "Discussion on \"SQL - TRUNCATE VS DELETE DIFFERENCE\". TRUNCATEDELETEIt is DDL command.It is DML command.It does not support where clause.It is support where clause.It is permanent delete.It is temporary deletion.It delete all table but keeps it's structu"
url: "https://hashnode.com/posts/sql-truncate-vs-delete-difference/6a7a33c13625acf6fc42c7e0"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [SQL - TRUNCATE VS DELETE DIFFERENCE](https://blagos.hashnode.dev/sql-truncate-vs-delete-difference?utm_source=hashnode&utm_medium=feed)

TRUNCATEDELETEIt is DDL command.It is DML command.It does not support where clause.It is support where clause.It is permanent delete.It is temporary deletion.It delete all table but keeps it's structu

Aug 10 · 1 min read · blagos.hashnode.dev  
Read the article

## Written by

[The Noid](https://hashnode.com/@thenoid)

@thenoid · Pune, India

  
[View profile](https://hashnode.com/@thenoid)

SYSTEMS DON'T SLEEP. NEITHER DO I.

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
