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!

[@sohammajumder9743]

Your voice is very sweet 🥺🥺🥺

[@foodloverchannel1820]

kzbin.info/www/bejne/j3qTZ4ZjZdl0pcU

[@justinrocky6645]

kzbin.info/www/bejne/j3qTZ4ZjZdl0pcU

[@simranbanwait]

Sigma male never simp , anyways thanks for the video mam

[@ANURAGSINGH-nl2ll]

Aww😂

[@Youcefstark]

😂😂😂

[@kavitha-99]

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

[@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]

kzbin.info/www/bejne/j3qTZ4ZjZdl0pcU

[@foodloverchannel1820]

kzbin.info/www/bejne/j3qTZ4ZjZdl0pcU

[@foodloverchannel1820]

kzbin.info/www/bejne/j3qTZ4ZjZdl0pcU

[@foodloverchannel1820]

kzbin.info/www/bejne/j3qTZ4ZjZdl0pcU

[@justinrocky6645]

kzbin.info/www/bejne/j3qTZ4ZjZdl0pcU

[@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]

kzbin.info/www/bejne/j3qTZ4ZjZdl0pcU

[@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]

👋

[@sohammajumder9743]

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

[@foodloverchannel1820]

kzbin.info/www/bejne/j3qTZ4ZjZdl0pcU

[@safarnaama8798]

Firoz Alam here, concepts are well explained.

[@Shreysanthu]

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

[@foodloverchannel1820]

kzbin.info/www/bejne/j3qTZ4ZjZdl0pcU

[@foodloverchannel1820]

kzbin.info/www/bejne/j3qTZ4ZjZdl0pcU

[@justinrocky6645]

kzbin.info/www/bejne/j3qTZ4ZjZdl0pcU

[@sank8277]

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

[@harishbmn]

Simple and clear. Be little louder mam.

[@foodloverchannel1820]

kzbin.info/www/bejne/j3qTZ4ZjZdl0pcU

[@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.

[@nagarajanerode]

Simple and to the point expected.

[@MiteshRathva]

Thank you 🙏

[@aakashsakharkar9349]

yes i m also able to understand this difference thanks

[@yashkhade]

Thank you this helped me.

[@IQBees]

Nice Explanation

[@digambar6191]

thnx☺☺

[@techconcepts1318]

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

[@justinrocky6645]

kzbin.info/www/bejne/j3qTZ4ZjZdl0pcU

[@mederamadan8945]

Hello from Kurdistan, Thank u varrrry🔥

[@doratv4892]

Thank you

[@meghnagupta313]

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

[@Nishant.420]

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

[@debarghyamukherjee7834]

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 =]

[@justinrocky6645]

kzbin.info/www/bejne/j3qTZ4ZjZdl0pcU

[@Ganeshay-09]

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

[@shashankdwivedi258]

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

[@recreate5421]

Informative 👍🏻

[@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.

[@naazvlogs12]

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

[@Shiva-zi9nw]

Very well explained

[@justinrocky6645]

kzbin.info/www/bejne/j3qTZ4ZjZdl0pcU

[@nagendrababu5740]

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

[@kashmeershaik9217]

Good explanation.. 😊😊👌

[@justinrocky6645]

kzbin.info/www/bejne/j3qTZ4ZjZdl0pcU

[@aayushisoni4009]

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

[@lavarajugiduturi2441]

yes

[@muralikrishna8882]

Thanks madam.

[@justinrocky6645]

kzbin.info/www/bejne/j3qTZ4ZjZdl0pcU

[@kannanr1827]

Good 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]

kzbin.info/www/bejne/j3qTZ4ZjZdl0pcU

[@HarshaSaivizagfan]

Syntax for delete and truncate

[@snigdharoy1938]

Good 👍

[@foodloverchannel1820]

kzbin.info/www/bejne/j3qTZ4ZjZdl0pcU

[@justinrocky6645]

kzbin.info/www/bejne/j3qTZ4ZjZdl0pcU

[@vipinkumark4476]

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

[@nancyguruswamy9488]

In delete we need to add commit ;

[@barkatulislam4639]

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

[@justinrocky6645]

kzbin.info/www/bejne/j3qTZ4ZjZdl0pcU

[@saltech2024]

Nice

[@venkateshgg9519]

super explenation

[@revanthm2982]

Need SQL notes. ..

[@sushilpal5460]

dulcet voice mam.....

[@justinrocky6645]

kzbin.info/www/bejne/j3qTZ4ZjZdl0pcU