Delphi Database, Delphi Components from ComponentAce
Products Download Order Contact us
TRUNCATE TABLE Command
Previous  Top  Next



TRUNCATE TABLE allows you to remove all rows from a table.

Syntax

TRUNCATE [ TABLE ] [ MEMORY ] table_name

Description

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.

MEMORY
If MEMORY keyword is specified before the table_name then an in-memory table will be truncated, not a disk one.  

table_name
The name of the table to be truncated.  

Example:

TRUNCATE TABLE developers  
 
Note:
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.


        © 2003 - 2024 ComponentAce  | .net zip component | barcode for .net | delphi zip component | delphi database Dec 03, 2024