truncate for College

truncate table dps_registrar_db.college_add_open_subjects;
truncate table dps_registrar_db.college_block_active_semester;
truncate table dps_registrar_db.college_block_subject_schedule;
truncate table dps_registrar_db.college_course;
truncate table dps_registrar_db.college_course_block;
truncate table dps_registrar_db.college_course_curriculum_2016_2017;
truncate table dps_registrar_db.college_course_curriculum_header;
truncate table dps_registrar_db.college_course_header;
truncate table dps_registrar_db.college_curriculum_prereqs_2016_2017;
truncate table dps_registrar_db.college_editsubject_history_2016_2017;
truncate table dps_registrar_db.college_enrolled_subjects_2016_2017;
truncate table dps_registrar_db.college_payment_fee_header;
truncate table dps_registrar_db.college_student_course_headers;
truncate table dps_registrar_db.college_subject_headers;
truncate table dps_registrar_db.college_subject_schedule;
truncate table dps_registrar_db.college_subject_size;
truncate table dps_registrar_db.college_transaction_header;
truncate table dps_registrar_db.college_yearlevel_sems_2015_2016;
truncate table dps_registrar_db.college_yearlevel_sems_2016_2017;
delete from dps_registrar_db.file_subject_name where subjname_iscollege = 1;