Tags: Programming Language.
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. It was officially introduced in the SQL:2008 standard.The TRUNCATE TABLE mytable statement is logically (though not physically) equivalent to the DELETE FROM mytable statement (without a WHERE clause).