Is it possible to delete from multiple tables in the same SQL statement?

by

Nope, you’d need to run multiple statements.

Because you need to delete from two tables, consider creating a temp table of the matching ids:

SELECT U.Id INTO #RecordsToDelete
FROM Users U
   JOIN LinkingTable J ON U.Id = J.U_Id
...

And then delete from each of the tables:

DELETE FROM Users 
WHERE Id IN (SELECT Id FROM #RecordsToDelete)

DELETE FROM LinkingTable
WHERE Id IN (SELECT Id FROM #RecordsToDelete)

More Related Contents:

  1. MS SQL “ON DELETE CASCADE” multiple foreign keys pointing to the same table?
  2. How do I edit a table in order to enable CASCADE DELETE?
  3. The multi-part identifier could not be bound
  4. Subquery using Exists 1 or Exists *
  5. How can I query a value in SQL Server XML column
  6. Most efficient T-SQL way to pad a varchar on the left to a certain length?
  7. SQL – How to store and navigate hierarchies?
  8. SQL Query to get aggregated result in comma separators along with group by column in SQL Server
  9. Update records in table from CTE
  10. Write a number with two decimal places SQL Server
  11. how can I Update top 100 records in sql server
  12. How to insert multiple records and get the identity value?
  13. Composite Primary key vs additional “ID” column?
  14. Can a sql server table have two identity columns?
  15. The SQL OVER() clause – when and why is it useful?
  16. Saving changes after table edit in SQL Server Management Studio
  17. Eliminating duplicate values based on only one column of the table
  18. Logging ALL Queries on a SQL Server 2008 Express Database?
  19. SQL query to find Nth highest salary from a salary table
  20. How to get export output in “real” CSV format in SQL Server Management Studio?
  21. Get the records of last month in SQL server
  22. Merge overlapping date intervals
  23. Script to save varbinary data to disk
  24. Access to Result sets from within Stored procedures Transact-SQL SQL Server
  25. alternatives to REPLACE on a text or ntext datatype
  26. How to find out what is locking my tables?
  27. Should I use the CASCADE DELETE rule? [duplicate]
  28. Dynamic order direction
  29. Why is RAND() not producing random numbers?
  30. SQL, How to Concatenate results?

Leave a Comment