Delete all rows in 2 tables with the same query

  • Thread starter Thread starter Hank Rouse
  • Start date Start date
H

Hank Rouse

DELETE *
FROM TEMP_IMPORT;

Which of course works, but what is the syntax for adding TBL2?

Thanks in Advance.
 
Hank said:
DELETE *
FROM TEMP_IMPORT;

Which of course works, but what is the syntax for adding TBL2?

Thanks in Advance.
Click to expand...

AFAIK you cannot delete from two tables with a single statement. Unless of
course referential intregrity cascades deletes to another table.
 
Back
Top