53  SQL TRUNCATE TABLE

Delete all rows the in the table. Since this is an optimized command different databases handles it differently.

• In Oracle, “Truncate table” is DDL command and it commits the transaction and could not be rolled back.

• In SQL server, it is DML command and works in transactions normally. See following stack overflow question.

• sqlite do not have “Truncate table” command.

• Sql Server Truncate table

• Oracle Truncate Table