How to delete project using queries in right sequence
Note: Take backup of your database before performing these scripts. Do not attempt to run these delete scripts in production environment. -- delete history of the project delete from EPUB_PR_HISTORY where project_id in ('prj213002','prj200001'); --delete history of the process delete from EPUB_PROC_HISTORY where process_id in (select process_id from epub_process where project in ('prj213002','prj200001')); -- delete task information of process delete from EPUB_PROC_TASKINFO where id in (select process_id from epub_process where project in ('prj213002','prj200001')); -- delete states of project delete from EPUB_IND_WORKFLOW where process_id in (select process_id from epub_process where project in ('prj213002','prj200001')); -- delete the process delete from epub_process where project in ('prj202001','prj213002'); -- Removing locks of the project if any delete from av...