Page Comparison

Find the study ID from the table 'os_oc_studies'

//SQL to cleanup the visits mapping table, where 'N' is the study ID

SQL>delete from os_oc_visits where subject_id in (select identifier from os_oc_subjects where study_id = N);

//SQL to cleanup the participant mapping table
delete, where 'N' is the study ID

SQL>delete from os_oc_subjects where study_id = N;

commit;