GNU/Linux man pages
Livre :
Expressions régulières,
Syntaxe et mise en oeuvre :
GNU/Linux |
CentOS 2.1AS(Slurm) |
|
 |
truncate(l) |
 |
TRUNCATE − Empty a table
TRUNCATE [ TABLE ] name
INPUTS
|
name |
The name of the table to be truncated. |
OUTPUTS
TRUNCATE
Message returned if the table is successfully truncated.
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 effective on large tables.
Truncate the table bigtable:
TRUNCATE TABLE bigtable;
SQL92
There is no TRUNCATE in SQL92.
|
truncate(l) | |