DELETE vs. DROP vs. TRUNCATE

Chloooo
3 min readAug 4, 2020

The Elegant Way of Deletion In Database

Photo by Javier Allegue Barros on Unsplash

Manipulating with data is common for IT professionals including database administrators, developers, data analysts and scientists, and playing with data in database is simple and straight forward. SQL is a specialized language for database operations and is very easy to understand and use. Unlike C or any other object-oriented programming, we try not to write SQL logics or…

--

--