Drop query in sqlite

Question

Possible duplicate

Hello all.

I have confusion in drop query that how actually it work in internally. I heard one of my post that someone says that when we use drop query then internally it'll be used delete query.

So my question is, Is it true that when we use the drop query then internally the delete query also use?

score 2 · Accepted Answer · edited Sep 19 '11 at 13:06

2

Usually it's the opposite - when you do "delete all" query the database will instead "drop" the table and then recreate it because that's faster than deleting all rows.

That's called "truncate optimization".

edited Sep 19 '11 at 13:06

Pratik

30,639
18
84
159

answered Sep 19 '11 at 12:51

sharptooth

167,383
100
513
979

You were wrong. suppose I have auto increament with primary key field than it'll be start with 1 not with the last value +1 try it. – Pratik Sep 19 '11 at 12:55
@Pratik: I guess SQLite developers took care of this. – sharptooth Sep 19 '11 at 12:58
it's not care if they re-create that means the whole schema will be recreated not only table and it's columns – Pratik Sep 19 '11 at 13:00
yes were right. If they recreate table then how can they manage the schemas? – Pratik Sep 19 '11 at 13:15
1

@Pratik: They could recreate the schema or anything like that. This would still be faster than deleting each row. – sharptooth Sep 19 '11 at 13:17

Drop query in sqlite

1 Answers1