TRUNCATE TABLE removes all rows from a table, but the table structure and its columns, constraints, indexes, and so on remain. To remove the table definition in addition to its data, use the DROP TABLE statement.

Does truncate mean DELETE?

TRUNCATE is a DDL(Data Definition Language) command and is used to delete all the rows or tuples from a table. Unlike the DELETE command, TRUNCATE command does not contain a WHERE clause. ... Unlike the DELETE command, the TRUNCATE command is fast.

Can truncate be rolled back?

Yes, a TRUNCATE can be rolled back in a transaction in SQL Server.