What is the difference between TRUNCATE and DELETE commands?
TRUNCATE is a DDL command whereas DELETE is a DML command.
TRUNCATE is much faster than DELETE.
truncate and delete both are used to delete data from SQL but the way they work is entirely different and quite important to understand to avoid crashing your database especially if you are working with a large data with huge data. when you delete data using delete command in SQL every row operation is logged and if you going to delete too much data your log segment may blew up, while with truncate its not the case. See here for more differences
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.