Sql query to delete from multiple tables

Sql query to delete parent child rows | cascade delete in sql server | same foreign key in multiple tables | delete from multiple tables sql server | how to enable cascade delete in sql server | foreign key constraint cascade delete | sql cascade delete example

Notes and Slides

SQL Server Tutorial for beginners

SQL Server Interview Questions and Answers

SQL Server Performance Tuning and Query Optimization

[Stelios.Posantzis]

Best quick intro to references, referential integrity and cascading deletes for SQL beginners I've seen so far

[bruh-vpwe]

Thank you very much, spent ages on the internet trying to find how to do this until I found your video on YouTube, it was a lifesaver!

[shivShaktitech]

Sir in this year's u had thought us sql big thanx for that, I have one request sir please release videos of no-sql for a change take it to next level.

[padhujangam]

Your teaching is awesomely understanding.

[hitendradeshmukh]

Thank you sir. The way you tech and the way you explain the topic is awesome it's directly hit into the brain. Once again thanks sir 👏👏👏👏👏👏👏👏👏👏👏👏👏

[danieljust]

Very clear explanation with real case scenarios.

[saedibrahim]

Thanks Sir, You always give perfect explanation.

[kiranmr]

Best ever tutor at YouTube please share all in one video on asp.net n c#

[Akmabedinkadersafi-O]

Best channel, best vedios on every topic that i learned. Going to complete all videos and practice them😍

[nandhukumar]

I used to ask this question in all my interviews. The explanation is good. 🙂

[MrXyzAbcdQwerty]

Hi Venkat, how about disabling the FK constraint(s); deleting the rows; and enabling the constraint(s)? Please advise.

[djjiang]

Thank you Venkat ! Good stuff as always !

[fin]

Based on your example is cascade delete faster if you are using FK? I am thinking it would not have to recheck the FK constraints again on the parent delete

[benterrell]

Golden info for newbie like me. Marvelous

[shravyachannel]

Big thanks to you sir, miku possible aithe ee course ni Telugu lo upload cheyandi sir because non IT students, and Telugu medium students kosam videos cheyandi sir, vallaki enka easy ga avuthundhi sir.

[omkaaaar]

Great Video! Can I request you to make video on following features of SSMS 1) SQL Jobs 2) Profiler vs xevent profiler 3)Database Tuning Adviser
Thanks 😊

[CAMG]

700 like from me and a sub, im starting to watch all your vids, gg for work 😊

[saikatbanerjee]

Only one key from composite primary key as foreign key- is this possible in sql server?

[jan]

You could also make a before delete trigger using instead-of trigger on the parent table which deletes the child rows first.

[jankichalise]

Awesome content. Keep posting content so that we can continue lerning :)