What is the difference between DROP and TRUNCATE?

Category: SQLWhat is the difference between DROP and TRUNCATE?
Editor">Editor Staff asked 2 years ago

What is the difference between DROP and TRUNCATE?

1 Answers
Editor">Editor Staff answered 2 years ago

TRUNCATE removes all rows from the table which cannot be retrieved back, DROP removes the entire table from the database and it also cannot be retrieved back.