TRUNCATE TABLE (Transact-SQL) [!INCLUDE sql-asdb-asdbmi-asa-pdw] Removes all rows from a table or specified partitions of a table, without logging the individual row deletions. TRUNCATE TABLE is ...

The `TRUNCATE` statement removes all data from the table in a non-transactional way. `TRUNCATE` can be thought of as semantically the same as `DROP TABLE` + `CREATE TABLE` with the previous definition ...