drop sequence fltid_gen;
drop sequence gmsgid_gen;
drop sequence imsgid_gen;
drop sequence paxid_gen;
drop sequence userid_gen;
drop sequence bag_trace_id;
drop sequence uld_trace_id;
drop sequence label_trace_id;
drop sequence log_id;
drop sequence bpmid_gen;
drop sequence trolley_uld_no_gen;
drop sequence flight_priv_id;
drop sequence user_trace_id;
drop sequence kitid_gen;
drop sequence flight_info_id;
drop sequence lbainfoid_gen;
drop sequence bsm_gen;
drop sequence uld_id_code_seq;
drop sequence report_id_gen;
drop sequence pmr_id_s;
drop sequence eql_id_s;
drop sequence kis_id_s;
drop sequence unb_id_s;
drop sequence wan_msg_id;
drop sequence handler_trace_seq;
drop sequence site_info_seq;
drop sequence event_type_id_seq;
drop sequence bagtag_tag_num_seq;
drop sequence gateway_redo_seq;
drop sequence bag_id_seq;
drop sequence inbound_uld_id_seq;
drop sequence inbound_pax_id_seq;
drop sequence inbound_bag_id_seq;
drop sequence message_id_seq;
drop sequence message_part_id_seq;
drop sequence bmm_route_id_seq;
drop sequence rule_id_seq;


set heading off;
select '-->', count(*), 'Sequences remain in this schema'
from user_sequences;
set heading on;
