Difference between Delete,Truncate and drop

Question

Post reply

Difference between Delete,Truncate and drop

vivekjamshedpur

Right there with Babe

Points: 740
More actions
November 29, 2014 at 3:07 pm

#312810

Comments posted to this topic are about the item Difference between Delete,Truncate and drop
December 1, 2014 at 1:43 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 15 total)

You must be logged in to reply to this topic. Login to reply

Hany Helmy SSChampion Points: 13921 More actions · Answer 1

Good question, and good example of using rollback within a transaction.

Thanx.

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

bharatmehra76 SSC Enthusiast Points: 101 More actions · Answer 2

bharatmehra76

SSC Enthusiast

Points: 101

November 30, 2014 at 6:08 am

#1761543

Can you tell me reason behind this?

ksatpute123 Hall of Fame Points: 3325 More actions · Answer 3

bharatmehra76 (11/30/2014)
Can you tell me reason behind this?

You can start with this:

http://blog.sqlauthority.com/2007/12/26/sql-server-truncate-cant-be-rolled-back-using-log-files-after-transaction-session-is-closed/

http://www.sqlservercentral.com/Forums/Topic1488704-391-1.aspx

If you are a beginner then you need to understand how DELETE, DROP and TRUNCATE work instead of just focusing on their theoretical differences.

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 4

Good question, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Umer Akram SSC-Insane Points: 22209 More actions · Answer 5

Nicely done, will help a lot of people especially newbies. Thanks for sharing

bharatmehra76 SSC Enthusiast Points: 101 More actions · Answer 6

thanks it helps to clear my doubts regarding truncate and delete operations 🙂

Michael_Garrison Hall of Fame Points: 3110 More actions · Answer 7

Michael_Garrison

Hall of Fame

Points: 3110

December 1, 2014 at 8:02 am

#1761735

Interesting question, learned something, thanks......

webrunner SSC-Dedicated Points: 31859 More actions · Answer 8

Great question, thanks!

- webrunner

-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

webrunner SSC-Dedicated Points: 31859 More actions · Answer 9

ksatpute123 (12/1/2014)
bharatmehra76 (11/30/2014)
Can you tell me reason behind this?
You can start with this:
http://blog.sqlauthority.com/2007/12/26/sql-server-truncate-cant-be-rolled-back-using-log-files-after-transaction-session-is-closed/
http://www.sqlservercentral.com/Forums/Topic1488704-391-1.aspx
If you are a beginner then you need to understand how DELETE, DROP and TRUNCATE work instead of just focusing on their theoretical differences.

Thank you. I like to see a reference article in the answer and didn't see one for this question. Other than that, it was an excellent question submission.

- webrunner

-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

Ed Wagner SSC Guru Points: 287026 More actions · Answer 10

Good question. Like another thread currently on the forum, it highlights the differences between DELETE and TRUNCATE in SQL Server and Oracle. Good question to start the week. Thanks.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Brian Hibbert Ten Centuries Points: 1322 More actions · Answer 11

This appears to be a major difference between SQL Server and Oracle. Oracle cannot roll back DDL, only DML. SQL Server seems to be able to do both.

Great question. Got me researching....

farhat.ullah Grasshopper Points: 13 More actions · Answer 12

delete and truncate both delete data from table but the difference is that when we use delete then we have option to delete some specific records from table but truncate delete all records from table.drop delete structure of table.means drop remove table from database.

softsuresh_05 SSC Rookie Points: 36 More actions · Answer 13

softsuresh_05

SSC Rookie

Points: 36

December 2, 2014 at 4:07 am

#1761993

Query 1 : 'abc'

Query 2 : 'abc'

Query 3 : 'abc'