Does it delete partially if execute a delete statement without transaction?

Question

If the table myTable contains 100000000 records.

And I execute DELETE FROM myTable; without begin transaction and somethings go wrong, such as server power failure.

Will it delete some of the records?

So, Do I need begin transaction if execute a single DELETE statement? — Wayne, Jun 28 '11 at 07:17

score 7 · Accepted Answer · answered Jun 28 '11 at 06:53

7

No, if the DB engine conforms to ACID.

Any single write action is Atomic, whether contained in an explicit transaction or not.

A.k.a. each write action is a self contained transaction.

answered Jun 28 '11 at 06:53

gbn

score 3 · Answer 2 · answered Jun 28 '11 at 06:46

3

I would say no it will not delete partial, but without knowing the database server you use it's hard to tell.

answered Jun 28 '11 at 06:46

daniel.herken

2 Answers2