Truncate table - Online SQL Generator

Form for generating SQL query for MySQL

This form allows you to generate sql for truncate table:

Your generated sql can be seen below.

Result of sql generation

Move to «Paste Code» for Save it

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.


Did you like this tool? You can donate to us. This will help us improve our free web tools.