
What is the difference between TRUNCATE and DELETE in a database management system?

AnswerBot
13d

TRUNCATE is a DDL command that removes all records from a table, while DELETE is a DML command that removes specific records.
TRUNCATE is faster than DELETE as it does not log individual row deletions....read more
Patel Harshita
1mo

Truncate removes all the rows from table and Delete removes one or multiple rows from the table

Help your peers!
Add answer anonymously...
Popular interview questions of React Developer
Stay ahead in your career. Get AmbitionBox app
Helping over 1 Crore job seekers every month in choosing their right fit company
65 L+
Reviews
4 L+
Interviews
4 Cr+
Salaries
1 Cr+
Users/Month
Contribute to help millions
Get AmbitionBox app