Question

truncate in sql means

Answer 1

In SQL, the TRUNCATE TABLE statement is a Data DefinitionLanguage (DDL) operation that marks the extents of a table for deallocation (empty for reuse). The result of this operation quickly removes all data from a table, typically bypassing a number of integrity enforcing mechanisms.

Answer 2

Truncate is used to remove all the records from a table.