Truncate table - Online SQL Generator
Form for generating SQL query for MySQL
This form allows you to generate sql for truncate table:
Result of sql generation
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.