Msql - Squirrel
From Blue-IT.org Wiki
Tables
TRUNCATE
To delete all table data but preserve the table data do:
TRUNCATE TABLE [datatbase].[prefix].[tablename]
To delete all table data but preserve the table data do:
TRUNCATE TABLE [datatbase].[prefix].[tablename]