Open Source Tutorials - Open Source Training
Open source training & tutorials from experienced, passionate people
chrome icon firefox icon ie icon opera icon safari icon Sings in these Browsers
A- A A+

By A Web Design

Welcome, Guest
Username Password: Remember me

Difference between Drop,Delete and Truncate Table
(1 viewing) (1) Guest
All your queries regarding
MySQL Installation,
Learning MySQL DBA,
and tonnes more... will be solved in this forum
  • Page:
  • 1
TOPIC:

Difference between Drop,Delete and Truncate Table

Difference between Drop,Delete and Truncate Table 1 year, 9 months ago #108

  • sami
  • OFFLINE
  • Junior Boarder
  • Posts: 24
  • Karma: 0
What is the difference among “dropping a table”, “truncating a table” and “deleting all records” from a table.

Re:Difference between Drop,Delete and Truncate Table 1 year, 9 months ago #109

  • abott
  • OFFLINE
  • Junior Boarder
  • Posts: 25
  • Karma: 0
Dropping a table will drop the table structure as well as data. Invalidates the dependent objects and also drops the indexes.

Truncating a table will truncate data only. It performs an automatic commit and is faster than delete operation.

Delete a table will delete data only.
It doesn’t perform automatic commit like Truncating operation.
  • Page:
  • 1
Time to create page: 1.19 seconds
OSV Newsletter


Receive HTML?

NOTE: To prevent subscription to the OSV newsletter, uncheck the checkbox above.
Guest Blog for OSV
Free Ebook Download