select pretty_name from pb_packages where pkg_id = :pkg_id delete from pb_attributes where type_id in (select type_id from pb_types where pkg_id = :pkg_id) delete from pb_types where pkg_id = :pkg_id delete from pb_packages where pkg_id = :pkg_id