CODEWITHSUNDEEP
databasesqlitedrop-table
Pratik
Pratik

Reputation: 30855

Drop query in sqlite

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?

Upvotes: 1

Views: 131

Answers (1)

sharptooth
sharptooth

Reputation: 170479

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".

Upvotes: 2

Related Questions