Truncate (SQL)

The Truncate statement removes all the data from a table. To be exact it creates a temp table with the same form as the original table. It then performs a drop on the original table and then performs a create table from the temp table. This is a very final way of removing the data from a table. DELETE is another way that may be more suitable as it doesnt drop the table.