0

I wanna delete two rows from two tables which are foreign key related how can i delete the two rows from that two tables at a time using the single delete statement. Can any body help me by just posting some example?

Febin J S
  • 1,358
  • 3
  • 26
  • 53

1 Answers1

1

Look: deleting records from multiple tables at a time with a single query in sqlserver2005

Community
  • 1
  • 1
Dalex
  • 3,585
  • 19
  • 25
  • i have seen that but it is not helping me – Febin J S Apr 29 '11 at 08:42
  • 2
    @Febin - that is because there is no way that I know of to do what you want with a *single* delete statement. A delete can only delete from *one* table (forgetting cascading deletes/triggers and the like). – Lieven Keersmaekers Apr 29 '11 at 08:54