What is the difference between Delete and Truncate?

Truncate delete all data from the table and we can not use where cluase. truncate recreate table stracture. delete used for remove all data from the table but we can use where cluase as per our requirement like one row and multiple conditions

1)Delete can be undone using rollback but we can not rollback truncate . 2) in delete we can delete specific record but in truncate all record get deleted

DELETE is DML command and TRUNCATE is DDL command. DELETE deletes records one by one and makes an entry for each and every deletion in the transaction log, whereas TRUNCATE de-allocates pages and makes an entry for de-allocation of pages in the transaction log

DELETE The DELETE command is used to delete specified rows(one or more). It is a DML(Data Manipulation Language) command. There may be WHERE clause in DELETE command in order to filter the records. In the DELETE command, a tuple is locked before removing it. We can rollback the data even after using DELETE command. DELETE command is slower than TRUNCATE command. TRUNCATE This command is used to delete all the rows from a table. It is a DDL(Data Definition Language) command. There is no WHERE clause in TRUNCATE command. In this command, data page is locked before removing the table data. In this command, we can’t rollback. TRUNCATE command is faster than DELETE command.

In Delete, the identity values are not removed in sequence. In truncate there is hard reset done on table. So, sequence remains unaltered in case of delete.

Delete is DML command. In which you can specify the tuple that you want to delete. Truncate is DDL command. It deletes all the tuples from a relation.

Well, TRUNCATE remove all the rows from tables , while delete can work with conditions.