DROP SEQUENCE AlternateTitle_ID_seq;
DROP SEQUENCE CI_Address_ID_seq;
DROP SEQUENCE CI_Citation_ID_seq;
DROP SEQUENCE CI_Contact_ID_seq;
DROP SEQUENCE CI_OnLineFunctionCode_ID_seq;
DROP SEQUENCE CI_OnlineResource_ID_seq;
DROP SEQUENCE CI_PresentationFormCode_ID_seq;
DROP SEQUENCE CI_RespParty_ID_seq;
DROP SEQUENCE CI_RoleCode_ID_seq;
DROP SEQUENCE CI_Series_ID_seq;
DROP SEQUENCE CSW_CouplingType_ID_seq;
DROP SEQUENCE CSW_ServiceIdentificati_ID_SEQ;
DROP SEQUENCE DeliveryPoint_ID_seq;
DROP SEQUENCE DQ_ConformanceResult_ID_seq ;
DROP SEQUENCE DQ_DataQuality_ID_seq;
DROP SEQUENCE DQ_Element_ID_seq;
DROP SEQUENCE DQ_QuantitativeResult_ID_seq ;
DROP SEQUENCE DS_AssociationTypeCode_ID_seq;
DROP SEQUENCE ElectronicMailAddress_ID_seq;
DROP SEQUENCE EX_BoundingPolygon_ID_seq;
DROP SEQUENCE EX_GeographicDescriptio_ID_SEQ;
DROP SEQUENCE EX_GeogrBBox_ID_seq;
DROP SEQUENCE EX_TemporalExtent_ID_seq;
DROP SEQUENCE EX_VerticalExtent_ID_seq;
DROP SEQUENCE Facsimile_ID_seq;
DROP SEQUENCE FAILEDREQUESTS_ID_seq;
DROP SEQUENCE FeatureTypes_ID_seq;
DROP SEQUENCE FileIdentifier_ID_seq;
DROP SEQUENCE HierarchylevelCode_ID_seq;
DROP SEQUENCE HierarchylevelName_ID_seq;
DROP SEQUENCE Keyword_ID_seq;
DROP SEQUENCE Language_ID_seq ;
DROP SEQUENCE LI_ProcessStep_ID_seq;
DROP SEQUENCE LI_Source_ID_seq;
DROP SEQUENCE MD_AggregateInfo_ID_seq;
DROP SEQUENCE MD_ApplicationSchemaInf_ID_SEQ;
DROP SEQUENCE MD_BrowseGraphic_ID_seq;
DROP SEQUENCE MD_CharacterSetCode_ID_seq;
DROP SEQUENCE MD_ClassificationCode_ID_seq;
DROP SEQUENCE MD_Constraints_ID_seq ;
DROP SEQUENCE MD_DataIdentification_ID_seq;
DROP SEQUENCE MD_DigTransferOpt_ID_seq;
DROP SEQUENCE MD_Distribution_ID_seq;
DROP SEQUENCE MD_Distributor_ID_seq;
DROP SEQUENCE MD_FeatCatDesc_ID_seq;
DROP SEQUENCE MD_Format_ID_seq;
DROP SEQUENCE MD_GeoObjTypeCode_ID_seq;
DROP SEQUENCE MD_Identification_ID_seq;
DROP SEQUENCE MD_Keywords_ID_seq;
DROP SEQUENCE MD_KeywordTypeCode_ID_seq;
DROP SEQUENCE MD_LegalConstraints_ID_seq;
DROP SEQUENCE MD_MainFreqCode_ID_seq;
DROP SEQUENCE MD_MaintenanceInformati_ID_SEQ;
DROP SEQUENCE MD_MediumFormatCode_ID_seq;
DROP SEQUENCE MD_MediumNameCode_ID_seq;
DROP SEQUENCE MD_Metadata_ID_seq;
DROP SEQUENCE MD_PortrayalCatRef_ID_seq;
DROP SEQUENCE MD_ProgressCode_ID_seq;
DROP SEQUENCE MD_Resolution_ID_seq;
DROP SEQUENCE MD_RestrictionCode_ID_seq;
DROP SEQUENCE MD_ScopeCode_ID_seq;
DROP SEQUENCE MD_SecurityConstraints_ID_seq;
DROP SEQUENCE MD_SpatialRepTypeCode_ID_seq;
DROP SEQUENCE MD_StandOrderProc_ID_seq;
DROP SEQUENCE MD_TopicCategoryCode_ID_seq;
DROP SEQUENCE MD_TopoLevelCode_ID_seq;
DROP SEQUENCE MD_Usage_ID_seq;
DROP SEQUENCE MD_VectorSpatialReprens_ID_SEQ;
DROP SEQUENCE OperatesOn_ID_seq;
DROP SEQUENCE OperationNames_ID_seq;
DROP SEQUENCE OtherConstraints_ID_seq;
DROP SEQUENCE PT_Locale_ID_seq;
DROP SEQUENCE PublicationDate_ID_seq ;
DROP SEQUENCE QuantitativeRes_Value_ID_seq ;
DROP SEQUENCE RS_Identifier_ID_seq;
DROP SEQUENCE ServiceVersion_ID_seq;
DROP SEQUENCE SV_DCPList_ID_seq;
DROP SEQUENCE SV_OperationMetadata_ID_seq;
DROP SEQUENCE SV_Parameter_ID_seq;
DROP SEQUENCE Voice_ID_seq;


DROP TABLE AlternateTitle CASCADE CONSTRAINT PURGE;
DROP TABLE CI_Address  CASCADE CONSTRAINT PURGE;
DROP TABLE CI_Citation  CASCADE CONSTRAINT PURGE;
DROP TABLE CI_Contact  CASCADE CONSTRAINT PURGE;
DROP TABLE CI_OnLineFunctionCode  CASCADE CONSTRAINT PURGE;
DROP TABLE CI_OnlineResource  CASCADE CONSTRAINT PURGE;
DROP TABLE CI_PresentationFormCode  CASCADE CONSTRAINT PURGE;
DROP TABLE CI_RespParty  CASCADE CONSTRAINT PURGE;
DROP TABLE CI_RoleCode  CASCADE CONSTRAINT PURGE;
DROP TABLE CI_Series  CASCADE CONSTRAINT PURGE;
DROP TABLE CSW_CouplingType  CASCADE CONSTRAINT PURGE;
DROP TABLE CSW_ServiceIdentification  CASCADE CONSTRAINT PURGE;
DROP TABLE DeliveryPoint  CASCADE CONSTRAINT PURGE;
DROP TABLE DQ_ConformanceResult CASCADE CONSTRAINT PURGE;
DROP TABLE DQ_DataQuality  CASCADE CONSTRAINT PURGE;
DROP TABLE DQ_Element  CASCADE CONSTRAINT PURGE;
DROP TABLE DQ_QuantitativeResult CASCADE CONSTRAINT PURGE;
DROP TABLE DS_AssociationTypeCode CASCADE CONSTRAINT PURGE;
DROP TABLE ElectronicMailAddress  CASCADE CONSTRAINT PURGE;
DROP TABLE EX_BoundingPolygon  CASCADE CONSTRAINT PURGE;
DROP TABLE EX_GeographicDescription  CASCADE CONSTRAINT PURGE;
DROP TABLE EX_GeogrBBox  CASCADE CONSTRAINT PURGE;
DROP TABLE EX_TemporalExtent  CASCADE CONSTRAINT PURGE;
DROP TABLE EX_VerticalExtent  CASCADE CONSTRAINT PURGE;
DROP TABLE Facsimile  CASCADE CONSTRAINT PURGE;
DROP TABLE FAILEDREQUESTS  CASCADE CONSTRAINT PURGE;
DROP TABLE FeatureTypes  CASCADE CONSTRAINT PURGE;
DROP TABLE FileIdentifier  CASCADE CONSTRAINT PURGE;
DROP TABLE HierarchylevelCode  CASCADE CONSTRAINT PURGE;
DROP TABLE HierarchylevelName  CASCADE CONSTRAINT PURGE;
drop table jt_address_delivpoint  CASCADE CONSTRAINT PURGE;
drop table jt_address_email  CASCADE CONSTRAINT PURGE;
drop table jt_citation_presform  CASCADE CONSTRAINT PURGE;
DROP TABLE JT_Citation_RespParty  CASCADE CONSTRAINT PURGE;
DROP TABLE JT_Citation_Ident  CASCADE CONSTRAINT PURGE;
DROP TABLE JT_DataIdent_CharSet  CASCADE CONSTRAINT PURGE;
DROP TABLE JT_DataIdent_SpatialRepType  CASCADE CONSTRAINT PURGE;
DROP TABLE JT_DataIdent_TopicCat  CASCADE CONSTRAINT PURGE;
DROP TABLE JT_DigTransOpt_MediumFormat  CASCADE CONSTRAINT PURGE;
DROP TABLE JT_DigTransOpt_MediumName  CASCADE CONSTRAINT PURGE;
DROP TABLE JT_DigTransOpt_OnlineRes  CASCADE CONSTRAINT PURGE;
DROP TABLE JT_Dist_DistFormat  CASCADE CONSTRAINT PURGE;
DROP TABLE JT_Dist_Distributor  CASCADE CONSTRAINT PURGE;
DROP TABLE JT_Ident_Const  CASCADE CONSTRAINT PURGE;
DROP TABLE JT_Ident_Keywords  CASCADE CONSTRAINT PURGE;
DROP TABLE JT_Ident_LegalConst  CASCADE CONSTRAINT PURGE;
DROP TABLE JT_Ident_Mainten  CASCADE CONSTRAINT PURGE;
DROP TABLE JT_Ident_Progress  CASCADE CONSTRAINT PURGE;
DROP TABLE JT_Ident_RespParty  CASCADE CONSTRAINT PURGE;
DROP TABLE JT_Ident_SecConst  CASCADE CONSTRAINT PURGE;
DROP TABLE JT_Ident_Usage  CASCADE CONSTRAINT PURGE;
DROP TABLE JT_Keywords_Keyword  CASCADE CONSTRAINT PURGE;
DROP TABLE JT_LegalConst_accessConst  CASCADE CONSTRAINT PURGE;
DROP TABLE JT_LegalConst_useConst  CASCADE CONSTRAINT PURGE;
DROP TABLE JT_Procstep_RespParty  CASCADE CONSTRAINT PURGE;
DROP TABLE JT_LI_SRC_LI_PROCSTEP  CASCADE CONSTRAINT PURGE;
DROP TABLE JT_Metadata_AppSchemaInf  CASCADE CONSTRAINT PURGE;
DROP TABLE JT_Metadata_Const  CASCADE CONSTRAINT PURGE;
DROP TABLE JT_Metadata_FeatCatDesc  CASCADE CONSTRAINT PURGE;
DROP TABLE JT_Metadata_LegalConst  CASCADE CONSTRAINT PURGE;
drop table jt_metadata_locale  CASCADE CONSTRAINT PURGE;
DROP TABLE JT_Metadata_PortCatRef  CASCADE CONSTRAINT PURGE;
DROP TABLE JT_Metadata_RefSys  CASCADE CONSTRAINT PURGE;
DROP TABLE JT_Metadata_RespParty  CASCADE CONSTRAINT PURGE;
DROP TABLE JT_Metadata_SecConst  CASCADE CONSTRAINT PURGE;
DROP TABLE JT_Operation_DCP  CASCADE CONSTRAINT PURGE;
DROP TABLE JT_Operation_Name  CASCADE CONSTRAINT PURGE;
DROP TABLE JT_Operation_OperatesOn  CASCADE CONSTRAINT PURGE;
DROP TABLE JT_Operation_Parameter  CASCADE CONSTRAINT PURGE;
DROP TABLE JT_OpMeta_OnlineRes  CASCADE CONSTRAINT PURGE;
DROP TABLE JT_Quality_Procstep  CASCADE CONSTRAINT PURGE;
DROP TABLE JT_SecConst_ClassificationCode  CASCADE CONSTRAINT PURGE;
DROP TABLE JT_Usage_RespParty  CASCADE CONSTRAINT PURGE;
DROP TABLE Keyword  CASCADE CONSTRAINT PURGE;
DROP TABLE Language CASCADE CONSTRAINT PURGE;
DROP TABLE LI_ProcessStep  CASCADE CONSTRAINT PURGE;
DROP TABLE LI_Source  CASCADE CONSTRAINT PURGE;
DROP TABLE MD_AggregateInfo  CASCADE CONSTRAINT PURGE;
DROP TABLE MD_AppSchemaInformation  CASCADE CONSTRAINT PURGE;
DROP TABLE MD_BrowseGraphic  CASCADE CONSTRAINT PURGE;
DROP TABLE MD_CharacterSetCode  CASCADE CONSTRAINT PURGE;
DROP TABLE MD_ClassificationCode  CASCADE CONSTRAINT PURGE;
DROP TABLE MD_Constraints  CASCADE CONSTRAINT PURGE;
DROP TABLE MD_DataIdentification  CASCADE CONSTRAINT PURGE;
DROP TABLE MD_DigTransferOpt  CASCADE CONSTRAINT PURGE;
DROP TABLE MD_Distribution  CASCADE CONSTRAINT PURGE;
DROP TABLE MD_Distributor  CASCADE CONSTRAINT PURGE;
DROP TABLE MD_FeatCatDesc  CASCADE CONSTRAINT PURGE;
DROP TABLE MD_Format  CASCADE CONSTRAINT PURGE;
DROP TABLE MD_GeoObjTypeCode  CASCADE CONSTRAINT PURGE;
DROP TABLE MD_Identification  CASCADE CONSTRAINT PURGE;
DROP TABLE MD_Keywords  CASCADE CONSTRAINT PURGE;
DROP TABLE MD_KeywordTypeCode  CASCADE CONSTRAINT PURGE;
DROP TABLE MD_LegalConstraints  CASCADE CONSTRAINT PURGE;
DROP TABLE MD_MainFreqCode  CASCADE CONSTRAINT PURGE;
DROP TABLE MD_MaintenanceInformation  CASCADE CONSTRAINT PURGE;
DROP TABLE MD_MediumFormatCode  CASCADE CONSTRAINT PURGE;
DROP TABLE MD_MediumNameCode  CASCADE CONSTRAINT PURGE;
DROP TABLE MD_Metadata  CASCADE CONSTRAINT PURGE;
DROP TABLE MD_PortrayalCatRef  CASCADE CONSTRAINT PURGE;
DROP TABLE MD_ProgressCode  CASCADE CONSTRAINT PURGE;
DROP TABLE MD_Resolution  CASCADE CONSTRAINT PURGE;
DROP TABLE MD_RestrictionCode  CASCADE CONSTRAINT PURGE;
DROP TABLE MD_ScopeCode  CASCADE CONSTRAINT PURGE;
DROP TABLE MD_SecurityConstraints  CASCADE CONSTRAINT PURGE;
DROP TABLE MD_SpatialRepTypeCode  CASCADE CONSTRAINT PURGE;
DROP TABLE MD_StandOrderProc  CASCADE CONSTRAINT PURGE;
DROP TABLE MD_TopicCategoryCode  CASCADE CONSTRAINT PURGE;
DROP TABLE MD_TopoLevelCode  CASCADE CONSTRAINT PURGE;
DROP TABLE MD_Usage  CASCADE CONSTRAINT PURGE;
DROP TABLE MD_VecSpatialRep  CASCADE CONSTRAINT PURGE;
DROP TABLE OperatesOn  CASCADE CONSTRAINT PURGE;
DROP TABLE OperationNames  CASCADE CONSTRAINT PURGE;
DROP TABLE OtherConstraints  CASCADE CONSTRAINT PURGE;
DROP TABLE PT_Locale  CASCADE CONSTRAINT PURGE;
DROP TABLE PublicationDate  CASCADE CONSTRAINT PURGE;
DROP TABLE QuantitativeRes_Value  CASCADE CONSTRAINT PURGE;
DROP TABLE RS_Identifier  CASCADE CONSTRAINT PURGE;
DROP TABLE ServiceVersion  CASCADE CONSTRAINT PURGE;
DROP TABLE SV_DCPList  CASCADE CONSTRAINT PURGE;
DROP TABLE SV_OperationMetadata  CASCADE CONSTRAINT PURGE;
DROP TABLE SV_Parameter  CASCADE CONSTRAINT PURGE;
DROP TABLE Voice  CASCADE CONSTRAINT PURGE;
commit;