Question

What is the meaning of truncate table in sql?

Answer 1

In SQL, the TRUNCATE TABLE statement is a [Data Definition Language] (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.