Sql query to delete from multiple tables 

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

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

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

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.

As Many people asking please make more videos on SQL

Your teaching is awesomely understanding.

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

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 👏👏👏👏👏👏👏👏👏👏👏👏👏

Very clear explanation with real case scenarios.

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

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

Thanks Sir, You always give perfect explanation.

Hi Sir, I love your content. Also, please make videos on SSIS.

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

Golden info for newbie like me. Marvelous

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.

6:20 This is also a really dangerous query as it only tells you the affected rows in the Gender tables and don't tell you anything about the other 4 rows deleted from the Students and Teachers table.

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 😊

Hey there sir. Big fan of the works, would really appreciate if you could also teach us advanced sql server. Thank You

Removing FK constraints or enabling cascading deletes isn't really using a query to delete from multiple tables. The last example is more work than just deleting the data via multiple queries. I was hoping for a cool trick where you could use a delete force command or something. I don't want to spend more time to delete.

Great explanation and examples

Oh wow, the organization must be seriously downsizing if they are deleting entire departments 😊 Good explanation though.

Many thanks sir, but can we do same action with access database? Or do you have any advice? Thanks and regards

Please make a video on Grouping sets and Roll Up function with multiple tables joined! Great video appreciate it!👍

Kudvenkat please post more sql related videos your sql server videos is awesome.

thank you so much for such nice explanation. Finding it very usefull

Hello. Thanks for this video. But I am working with a huge database in which more than 30 tables are referencing the primary key of a table. In this case is there any alternate way of deleting entries from child table without writing explicit 30 delete commands for 30 child tables?

Thank you Venkat ! Good stuff as always !

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

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

In your video @7:36 you are deleting the child records first and then the parent record, so why do you need to remove the FK first?

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

good explanation.. thanks sir..

How to write a query to display the most repeated value in a column?

Hi Kudvenkat, I am a new to SQL SERVER and recently the msdb database is in suspect recovery mode and all the databases are in recovery pending and SQL AGENT is not visible on the instance.My challenge is I can’t solve the problem as the file path after the sql server upgrade from sql 2016 to sql2019 is not recoverable as I tried to rebuild the msdb database.I moved the msdb and renamed it to make it easier to rebuild the msdb but to no avail.Please if you can do a video on msdb suspect recovery mode.Thank you! Keep it up you already helping plenty of people like myself. Thank you in advance.

Excellent video. Thanks a lot.

Using a function in where condition can impact query performance. If you are playing with big data

I have one doubt. Anyone can explain? He added constraint again. But where he took that constraint? Because drop constraint I could understand. But add constaint where he took?

While deleting tha large data log size is increasing even its in simple recovery any solution for how to limit the log size increasing??

Hi Venkat, Can you please do a video on parameter sniffing and what is the best approach to solve parameter sniffing problem?

Hello Sir, every topic you cover is something Motivational to me. I have a question, suppose we have multiple duplicate entries in the table A with identity column and also have foreign key reference constant with table B having multiple duplicates inserted into table B. Now how to delete duplicate rows from both the tables without changing to cascade

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

I watch all your videos.. great content. Can you please make Azure Synapse Analytics series ?

Thank you very much sir for this excellent tutorial!

Please sir upload video on if absentees of a particular student greater than certain condition then automatically alert message sent to that student that you are going to be dissmiss ( as.net mvc , sql server)

Hi venkat could you pease make video on fill factor and table partition

It is specific to Microsoft SQL or applicable for oracle also??

Thanks sir

Wat if both primary and foriegn key on the same table i.e.. a primary code that will be a parent for another primary code...plz reply sir

I am big fan sir

Hi Venkat. How to find out number of weekends in given month. How we can do that? Thanks in advance

Why you didn't deleted the HR depatrment?

Thanks for sharing

Hi Venkat can you make a videos on Snowflake Please with real time scenario's ? Please sir

Thanks

Hi sir, faced one question in interview like how to show only top 5 salary record in the result. They don't want top 5 command and something else they expected. Please help

Excellent..

Please I need a T-SQL script to delete multiple or all user databases in a server/instance

Misleading title - altering the foreign key (which you don't always have permission to do) is NOT an "sql query to delete from multiple tables" like you have in oracle...

When a record from parent table is to be deleted... Can we update a default value to be updated for the columns in the child tables instead of deleting them?? Can you explain that if that's possible?

Did I get it correctly, that cascading policy should be given when we create a table and is not changeable afterwards?

Hi Kudvenkat. Thanks for the video. Can you please make a video to show how to insert into, select delete and update several one to many tables. For example a table student, teacher, address, phone and email. Both the teacher and the students can have several phone number email, phone and address. Thank you

Hi Vankat, Can you please make video on Temporal table

Thank you sir,,

Anyone knows if exist some way to add intellisense code completion and auto-format T-SQL code in SQL Server Management Studio?

Thank you!

Thanks Bro.

good

Nice explanation

Nice video

How to use sql view in asp.net mvc?

what if we want to delete master data but don't want to lose transaction data?is it possible?if not, what is your suggestion?

Hey, can you record video about all kind of table joins (inner, outer, left)etc.

Hi Sir, I'm a 31 Y.O. undergraduate and unable to get a job because of my graduation status. I'm an OCA with good SQL knowledge. I'm stuck with 20K salary for the past few years. I've learnt alot from you. Please help me.

Great info. Thank you for this

Can you please teach us asp boilerplate

Cascade Delete Child First then -> Parent

Not sure what the goal is? "I should be able to cascade delete"? If yes, then it means I don't care of the implications or best practices, but I simply love to delete anything that comes in the way :)

anyone thinks the intro music has a Sopranos theme feel? Either way awesome

Delete cascade is a terrible thing to be adding, especially on large databases. You give users the ability to wipe out data they might not want to.

dear sir, hur man send email to customer email when his subscription come near to ending, thanks

Assume I have 15 columns I need to exclude only two columns in select So writing 13 columns takes time and increase size of query How to make short and concise

Gender its just M and F.

Which one you suggest? soft delete (isDeleted) or hard delete? Is there any method to track or retrieve deleted rows?

Awesome. Your video always gives good concept. Whenever I face confusion then I use to watch your videos.