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:
[e-mail]
✨If you appreciate my work and would like to donate to support our channel, you can do so here:
paypal.me/sadi...

[@crackconcepts]

✨Link to my SQL e-book: imojo.in/rkajq9
✨Link to 'Switch your career easily' e-book: imojo.in/1FL7KaG
(Perfect for anyone willing to switch to a completely new field or to a different company in the Tech World)

[@imanoo3]

Better explanation than my confused instructor. Thank you!

[@kavitha-99]

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

[@sohammajumder9743]

Your voice is very sweet 🥺🥺🥺

[@foodloverchannel1820]

th-cam.com/video/YI06S-0tAoc/w-d-xo.html

[@justinrocky6645]

th-cam.com/video/YI06S-0tAoc/w-d-xo.html

[@simranbanwait]

Sigma male never simp , anyways thanks for the video mam

[@ANURAGSINGH-nl2ll]

Aww😂

[@Youcefstark]

😂😂😂

[@sohammajumder9743]

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

[@foodloverchannel1820]

th-cam.com/video/YI06S-0tAoc/w-d-xo.html

[@subramaniang5265]

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.

[@foodloverchannel1820]

th-cam.com/video/YI06S-0tAoc/w-d-xo.html

[@foodloverchannel1820]

th-cam.com/video/YI06S-0tAoc/w-d-xo.html

[@foodloverchannel1820]

th-cam.com/video/YI06S-0tAoc/w-d-xo.html

[@foodloverchannel1820]

th-cam.com/video/YI06S-0tAoc/w-d-xo.html

[@justinrocky6645]

th-cam.com/video/YI06S-0tAoc/w-d-xo.html

[@Tanu-mw4jg]

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.

[@justinrocky6645]

th-cam.com/video/YI06S-0tAoc/w-d-xo.html

[@vinaykumar-xf5mo]

Go to Edit --> Preferences.
Click "SQL Editor" tab and uncheck "Safe Updates" (rejects UPDATEs and DELETEs with no restrictions) check box.
Query --> Reconnect to Server.

[@ArunKumar-ri4bo]

Hlo mam your explanation is very good and your voice also🥰

[@ArunKumar-ri4bo]

👋

[@shashankdwivedi258]

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

[@Shreysanthu]

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

[@foodloverchannel1820]

th-cam.com/video/YI06S-0tAoc/w-d-xo.html

[@foodloverchannel1820]

th-cam.com/video/YI06S-0tAoc/w-d-xo.html

[@justinrocky6645]

th-cam.com/video/YI06S-0tAoc/w-d-xo.html

[@nagarajanerode]

Simple and to the point expected.

[@yashkhade]

Thank you this helped me.

[@aakashsakharkar9349]

yes i m also able to understand this difference thanks

[@sank8277]

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

[@harishbmn]

Simple and clear. Be little louder mam.

[@foodloverchannel1820]

th-cam.com/video/YI06S-0tAoc/w-d-xo.html

[@vinaykumar-xf5mo]

Go to Edit --> Preferences.
Click "SQL Editor" tab and uncheck "Safe Updates" (rejects UPDATEs and DELETEs with no restrictions) check box.
Query --> Reconnect to Server.

[@safarnaama8798]

Firoz Alam here, concepts are well explained.

[@stargazingblindly]

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

[@justinrocky6645]

th-cam.com/video/YI06S-0tAoc/w-d-xo.html

[@MiteshRathva]

Thank you 🙏

[@mederamadan8945]

Hello from Kurdistan, Thank u varrrry🔥

[@IQBees]

Nice Explanation

[@doratv4892]

Thank you

[@Ganeshay-996]

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

[@recreate5421]

Informative 👍🏻

[@Nishant.420]

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

[@digambar6191]

thnx☺☺

[@Shiva-zi9nw]

Very well explained

[@justinrocky6645]

th-cam.com/video/YI06S-0tAoc/w-d-xo.html

[@debarghyamukherjee7834]

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

[@techconcepts1318]

The main difference between delete and truncate is, delete does not reset the identity value, truncate resets the identity value.

[@justinrocky6645]

th-cam.com/video/YI06S-0tAoc/w-d-xo.html

[@meghnagupta313]

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

[@naazvlogs12]

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

[@HarshaSaivizagfan]

Syntax for delete and truncate

[@kashmeershaik9217]

Good explanation.. 😊😊👌

[@justinrocky6645]

th-cam.com/video/YI06S-0tAoc/w-d-xo.html

[@nagendrababu5740]

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

[@vipinkumark4476]

Madam please attach the photo of that paper in discrimination.. It will. Be helpfull

[@kannanr1827]

Good one...👌👌👏👏

[@revanthm2982]

Need SQL notes. ..

[@venkateshgg9519]

super
explenation

[@nancyguruswamy9488]

In delete we need to add commit ;

[@muralikrishna8882]

Thanks madam.

[@justinrocky6645]

th-cam.com/video/YI06S-0tAoc/w-d-xo.html

[@ragavendrad574]

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 ?

[@apurvakulkarni9409]

I thought simply you can use desc table ....or select*from table...it shows you whether data present or not..... and one more way I thought is simply you give insert into table name(column parameters).. values (input according to column.. but take care of null not null and primary key..and insert value)..it will add new row without overwrite previous one.

[@hemayerubandi7015]

whta do mean by freeing the space here ? Delete from table and truncate table both will remove all the records from table .... What this space is about ? Kind of confused

[@justinrocky6645]

th-cam.com/video/YI06S-0tAoc/w-d-xo.html

[@saltech2024]

Nice

[@aayushisoni4009]

if i drop a database , all the tables under it will also be removed?

[@lavarajugiduturi2441]

yes

[@snigdharoy1938]

Good 👍

[@foodloverchannel1820]

th-cam.com/video/YI06S-0tAoc/w-d-xo.html

[@justinrocky6645]

th-cam.com/video/YI06S-0tAoc/w-d-xo.html

[@sushilpal5460]

dulcet voice mam.....

[@justinrocky6645]

th-cam.com/video/YI06S-0tAoc/w-d-xo.html

[@barkatulislam4639]

Ma'am I want a better career in IT please guide me 🙏🙏🙏

[@justinrocky6645]

th-cam.com/video/YI06S-0tAoc/w-d-xo.html