drop view PRETTY_PURCHASE; drop table YRB_BOOK; drop table YRB_CATEGORY; drop table YRB_CLUB; drop table YRB_CUSTOMER; drop table YRB_MEMBER; drop table YRB_OFFER; drop table YRB_PURCHASE; drop table YRB_SHIPPING;