|
1878.5.5
by Brian Aker
Additional documentation. |
1 |
TRUNCATE
|
2 |
========
|
|
3 |
||
|
1994.5.5
by Stewart Smith
add some notes on TRUNCATE, including things that should be expanded on |
4 |
FIXME: I don't think the below SERIAL/AUTO_INCREMENT thing below is true. |
5 |
||
|
1945.3.9
by Marisa Plumb
changes in cross-references |
6 |
This will delete all data in a table but unlike a DROP TABLE it will allow you to keep the table in your database. It deletes the rows but leaves all counters, such as a SERIAL, in place. :: |
|
1878.5.5
by Brian Aker
Additional documentation. |
7 |
|
|
1994.5.5
by Stewart Smith
add some notes on TRUNCATE, including things that should be expanded on |
8 |
|
|
1945.3.9
by Marisa Plumb
changes in cross-references |
9 |
TRUNCATE TABLE table_name |
|
1994.5.5
by Stewart Smith
add some notes on TRUNCATE, including things that should be expanded on |
10 |
|
11 |
TRUNCATE TABLE is typically faster than a DELETE * FROM TABLE query. An |
|
12 |
unbounded DELETE query will have to generate undo log data for every |
|
13 |
row in the table, which could be quite large. TRUNCATE TABLE is the same |
|
14 |
as DROP followed by CREATE except that the absence of the table between |
|
15 |
DROP and CREATE is not exposed. |
|
16 |