[MSSQL] 여러 테이블에서 데이터 삭제

 

 

 

DELETE USER A, CLIP B, NEWSLETTER C, AUTH D, SNS_INFO E
FROM A LEFT JOIN B
       ON A.USER_ID = B.USER_ID
       LEFT JOIN C
       ON B.USER_ID = C.USER_ID
       LEFT JOIN D
       ON C.USER_ID = D.USER_ID
       LEFT JOIN E
       ON D.USER_ID = E.USER_ID
WHERE A.USER_ID = #{userId}

 

 

 

 

 

참고 사이트

https://r-ayo.com/69

https://m.blog.naver.com/regenesis90/222190687396