The difference between a TRUNCATE TABLE statement and a DELETE table statement

TRUNCATE TABLE name;

Delete from table name;

is used to delete all the records in the table, the former delete the data after the table's identity column will restart numbering, it is more than the DELETE statement using the system resources and transaction log resources, but the table structure, columns, constraints, indexes, etc. will not be changed, it cannot be used in a table with a FOREIGN key constraint reference, and in practice it is not recommended to use TRUNCATE, because data deleted using it cannot be restored, and delete is used to recover

The difference between a TRUNCATE TABLE statement and a DELETE table statement