Coforge Interview Question: What is difference between delete and truncate in sql?

Skip to content Skip to footer

Community
Jobs
Companies
Salaries
For Employers

Notifications

Coforge

Coforge Graduate Engineer Trainee interview

Coforge Interview Question

Graduate Engineer Trainee Interview

What is difference between delete and truncate in sql?

Interview Answers

Anonymous

Mar 28, 2022

Delete is used in dml where truncate is used in dcl

Anonymous

Mar 23, 2025

Answer delete is used to delete a specific row we can use where clause and is a type of dml whereas truncate is used when we need to completely delete all rows in table and is type of ddl

Coforge interviews

Coforge

Coforge Interview Question

Interview Answers

Want the inside scoop on your own company?

Bowls

Followed companies

Job searches