Delete from multiple tables SQL

Question

I trying to figure out how I can delete from multiple tables in SQL Server.

I have one table containing only one primary key and three foreign keys for the three table I want to delete from. The other three table does not contain any foreign keys.

The stored procedure have one parameter, a specific primary key from one of the tables. I want to delete from the other tables WHERE tableID = @tableID. The constraints between the tables are set to cascade.

Is it possible with only that parameter to delete from all four tables?

I've tried with inner join, outer join, temptable..

Table      Table        Table      Table 
Pk         Pk(Fk1)      Pk(Fk2)    Pk(Fk3)
Fk1        Column       Column     Column
Fk2        Column       Column     Column
Fk3

I have the table 2 Pk as parameter.

Thanks, did not know it existed, will do!

s.e
– s.e

2012-04-01 19:43:19 +00:00
Commented Apr 1, 2012 at 19:43 — s.e
– s.e, Commented Apr 1, 2012 at 19:43

Diego · Accepted Answer · 2012-04-01 19:29:03Z

3

if your foreign keys were created with DELETE CASCADE, once you delete from the main table, all the related rows on the foreign tables will be delete too.

It seems like this is how it is configured, isnt it working?

answered Apr 1, 2012 at 19:29

Diego

36.5k21 gold badges94 silver badges138 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

s.e Over a year ago

That was what I was thinking, but it's not working. It only deletes from the table containing the primary key that is the parameter.

Diego Over a year ago

can you post your table and keys, so we can take a look?

Diego Over a year ago

sorry but I did not understand. It would be easier if you just posted the DDL of the tables involved. With the keys.

s.e Over a year ago

Solved it, I realized that I made it more complicated than it was.. And I realized that the databas is not well done. Thanks and sorry for taking up your time.

Collectives™ on Stack Overflow

Delete from multiple tables SQL

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related