Difference between DELETE, TRUNCATE AND DROP in SQL.

In this video, we'll understand the difference between DELETE, Truncate and drop. This is an important interview question.

✨Work related mails can be sent on:

✨If you appreciate my work and would like to donate to support our channel, you can do so here:

[crackconcepts]

(Perfect for anyone willing to switch to a completely new field or to a different company in the Tech World)

[imanoo]

Better explanation than my confused instructor. Thank you!

[kavitha-]

Very cleanly explained and straight to the point. Thank you!

[subramaniang]

Hi Mam, you are explaining in a very well manner and requesting to post similar kind of videos for SQL. Thanks for your good work and keep up the same.

[Tanu-mwjg]

Good one dear.But, just remove * from delete query bcoz it will give error.
Also, with respect to identity column there is a difference in between delete and truncate.In case of delete identity value is not reset while in case of truncate identity value gets reset to the initial seed value given in the table definition.

[sohammajumder]

I was facing a problem in finding the difference between these 3 but you helped me out

[safarnaama]

Firoz Alam here, concepts are well explained.

[sank]

Nice explanation.But remove that * in delete query.if we give * query wont work

[Shreysanthu]

Good teaching with good and clear voice .... thank you. Better you explain practically with SQL workbench please

[Ganeshay-]

TRUNCATE command delete all rows even that Table has Primary or Foreign Key . Right ?

[shashankdwivedi]

Ohh My God!!!! Your Voice is mesmerizing!!!!

[Nishant.]

And what about drop when we use it with alter fun. To drop column...?

[meghnagupta]

We do can use flashback after drop by checking is table shows still in recycle bin correct?

[aakashsakharkar]

yes i m also able to understand this difference thanks

[debarghyamukherjee]

you should have mentioned that DELETE can be rollbacked and not DROP & TRUNCATE... anyways, good explanation

[stargazingblindly]

Thank you very much you explained the difference very clearly =]

[mederamadan]

Hello from Kurdistan, Thank u varrrry🔥

[naazvlogs]

In this drop can be rolled back using Rollback-tcl statement right?

[ragavendrad]

Hi Madam,
I want to insert data to a table ....I need to check whether data exist before inserting data... Do we have anything like check constraints ?

[nagendrababu]

i think u missed (*, ) as star &cama in CTE query is it correct