This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Hi - I created a temporary table in my putput tool which will track all the deleted records and then added a post sql delete to remove those from that table. To identify the deleted records i used outer join and is_null condition to find the records that are removed. which worked good.
However now im facing a new challenge and added a new post for that. which is addressing forign keys . Deletion now happens if there are no dependencies on the records . But if the records primary key is referenced in other tables update/delete is failing with foreign key violation. So i need to take care of those tables first .
I know the tables, but not sure how to add these dependencies in my current workflow .