Truncate table - Online SQL Generator

This form allows you to generate sql for truncate table:

About this tool

The Truncate Table MySQL Generator was created to help with generating sql code for "Truncate table". No need to remember syntax and type required data, now you can easily generate an MySQL query online.

How it Works?

Just enter your "Table Name" to the input above and click to the button "Generate" and you will get your MySQL query.

Tip

TRUNCATE TABLE is used to delete the data inside a table, but not the table itself. Removes all rows from a table. TRUNCATE TABLE is similar to the DELETE statement with no WHERE clause. However, TRUNCATE TABLE is faster and uses fewer system and transaction log resources. Make sure you have admin privilege before running this command.