Truncate table - Online MySQL Generator

Form for generating MySQL query

This form allows you to generate sql for truncate table:

Your generated sql can be seen below.

Result of sql generation

Press F11 to switch to fullscreen mode
Move to "Paste Code" for Save

About "Truncate table MySQL generator"

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.


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.


Generator may contain errors, You execute queries at your own risk.