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).

Loading...

This page contains content from the copyrighted Wikipedia article "Truncate (SQL)"; that content is used under the GNU Free Documentation License (GFDL). You may redistribute it, verbatim or modified, providing that you comply with the terms of the GFDL.