oracle_clear.sql

此程序都是企业级 的数据库开发程序 全面揭示了JAVA对数据库的操作

REMARK drop the tables in reverse order

DROP Table SalesCampaigns;
DROP Table Inventories;
DROP Table Reviews	;
DROP Table CustomerOrderItems;
DROP Table Tracks	;
DROP Table Recordings;
DROP Table Languages;
DROP Table RecordingFormats;
DROP Table PublishersAndLabels;
DROP Table ArtistsAndPerformers;
DROP Table AudioStyles;
DROP Table CustomerOrders;
DROP Table OrderStatuses;
DROP Table OrderSources;
DROP Table Customers;
DROP Table CreditCardTypes;
DROP Table PaymentTerms;
DROP Table CustomerTypes;
DROP Table CustomerTitles;
DROP Table Stores;
DROP Table StoreTypes;
DROP Table PostalCodes;
DROP Table Countries;


REMARK Drop the sequences in any order

DROP SEQUENCE seqCountries;
DROP SEQUENCE seqStoreTypes;
DROP SEQUENCE seqStores;
DROP SEQUENCE seqCustomerTitles;
DROP SEQUENCE seqCustomerTypes;
DROP SEQUENCE seqPaymentTerms;
DROP SEQUENCE seqCreditCardTypes;
DROP SEQUENCE seqCustomers;
DROP SEQUENCE seqOrderSources;
DROP SEQUENCE seqOrderStatuses;
DROP SEQUENCE seqCustomerOrders;
DROP SEQUENCE seqAudioStyles;
DROP SEQUENCE seqArtistsAndPerformers;
DROP SEQUENCE seqPublishersAndLabels;
DROP SEQUENCE seqRecordingFormats;
DROP SEQUENCE seqLanguages;
DROP SEQUENCE seqRecordings;
DROP SEQUENCE seqReviews;
DROP SEQUENCE seqSalesCampaigns;