Version: Available or changed with runtime version 16.0. Deletes all records in a table that fall within a specified range, in an efficient maner. Keep in mind that Truncate allows for less ...
Version: Available or changed with runtime version 16.0. Deletes all records in a table that fall within a specified range, in an efficient maner. Keep in mind that Truncate allows for less ...
TRUNCATE TABLE empties a table completely. It requires the DROP privilege. See GRANT. tbl_name can also be specified in the form db_name.tbl_name (see Identifier Qualifiers). Logically, TRUNCATE TABLE ...
TRUNCATE is significantly faster than DELETE for removing all rows. TRUNCATE deallocates entire data pages in one operation. DELETE removes rows one at a time and logs each row deletion. TRUNCATE uses ...