<< Click to Display Table of Contents >>
TRUNCATE TABLE Command
TRUNCATE TABLE allows you to remove all rows from a table.
TRUNCATE [ TABLE ] [ MEMORY ] table_name
TRUNCATE quickly removes all rows from a table. It has the same effect as an unqualified DELETE but since it does not actually scan the table it is faster. This is most useful on large tables.
If MEMORY keyword is specified before the table_name then an in-memory table will be truncated, not a disk one.
The name of the table to be truncated.
TRUNCATE TABLE developers;
TRUNCATE requires exclusive access to the table whereas DELETE doesn't. So if you'd like to empty table open by another user, you should use DELETE command instead of TRUNCATE.__________________________