The best replacement for truncate is delete.

Лучшие альтернативы к truncate можно упорядочить следующим образом:
★★★★★  delete
★★★  delete sql
★★  drop
★★  drop table
★★  delete oracle
★  overburn
★  delete mysql
★  delete sql server
★  overburn gta v
★  delete which is faster
★  delete from
★  delete performance
★  overburn fifa 14
★  floor
★  delete db2
  drop and recreate table
  overburn xbox 360
  drop sql server
  overburn xgd3
  delete sql server 2008
  empty
  overburn imgburn
  delete table
  overburn xbox
  delete in sql
  drop mysql
  drop faster
  drop and create
  rounding
  shrink
  delete sql server 2005
  overburn dvd
  delete faster
  round excel

Ваша альтернатива к truncate не упомянута? Предложите!
Говоря о truncate, пожалуй, не стоит забывать о foreign key constraint.

Другие запросы относящиеся к truncate можно упорядочить так:
★★★★★ foreign key constraint
★★★ drop storage
Вам известен компаньон к truncate и он пока не упомянут тут? Предлагайте!



Google Trends

Scale is based on the average worldwide traffic of truncate in all years. Click on graph for more.
truncate
delete
delete sql