SQL TRUNCATE

SQL TRUNCATE is used to remove or delete the data contained in a table.

Useful when you just want to clear the data, but do not want to clear the table.

This statement leaves an empty table, ie no data.

TRUNCATE TABLE tableName