Home
Recent Q&A
Java
Cloud
JavaScript
Python
SQL
PHP
HTML
C++
Data Science
DBMS
Devops
Hadoop
Machine Learning
Azure
Blockchain
Devops
Ask a Question
what is the difference between TRUNCATE and DELETE statement?
Home
Sql
what is the difference between TRUNCATE and DELETE statement?
+1
vote
asked
Dec 24, 2023
in
Sql
by
john ganales
what is the difference between TRUNCATE and DELETE statement?
truncate
delete
Please
log in
or
register
to answer this question.
1
Answer
0
votes
answered
Dec 24, 2023
by
john ganales
The difference between TRUNCATE and DELETE statement is that,
TRUNCATE is used for unconditional removal of data records from Tables. Truncate Operations are not logged.
DELETE is used for conditional removal of data records from Tables. These operations are logged.
...
