A DDL operation that quickly removes all rows.
In Oracle and MySQL(depending on the storage engine) the operation is not transactional and cannot be rolled back.
In PostgreSQL and SQL Server the statement must be committed or rolled back.
Stats
created |
10 months ago |
viewed |
3 times |
active |
10 months ago |
editors |
1 |
Recent Hot Answers
Why use both TRUNCATE and DROP?Why use both TRUNCATE and DROP?
Why does DELETE leave a lingering effect on performance?
What factors prevent and delay TRUNCATE command?
PostgreSQL: Disk space not released after TRUNCATE
more »
Related Tags
sql-server × 5sql × 3
postgresql × 3
mysql × 3
oracle × 2
delete × 2
disk-space × 2
sql-server-2008
referential-integrity
mysql-5.5
sql-server-2012
errors
shrink
performance
mariadb
alter-table
oracle-11g
partitioning
index
locking
hints
transaction-log
select
sql-server-2005
corruption
