rem Generated for Warehouse Builder by UML Code Generator

drop table CMPFCOStorage cascade constraints;

drop table CMPMMMStorage cascade constraints;

drop table CMPSCOStorage cascade constraints;

drop table CMPSCOCfgStorage cascade constraints;

drop table CMPSCOMapStorage cascade constraints;

drop table CMPSCOPrpStorage cascade constraints;

drop table CMPSYSStorage cascade constraints;

drop view CMPRelation_X;
drop view CMPRelationalDBObject_X;
drop view CMPInstalledModule_X;
drop view CMPSharedInstalledModule_X;
drop view CMPWBDataWarehouse_X;
drop view CMPWBFileInstalledModule_X;
drop view CMPWBGatewayInstalledModule_X;
drop view CMPWBOracleInstalledModule_X;
drop view CMPWBPsftInstalledModule_X;
drop view CMPWBRepInstalledModule_X;
drop view CMPWBSAPInstalledModule_X;
drop view CMPXMLInstalledModule_X;
drop view CMPBinaryObject_X;
drop view CMPIcon_X;
drop view CMPBusinessRuleDefinition_X;
drop view CMPBusinessRuleItemParam_X;
drop view CMPBusinessRuleModule_X;
drop view CMPBusinessRuleRelParam_X;
drop view CMPBusinessRuleUsage_X;
drop view CMPDataRuleMap_X;
drop view CMPRelationUsage_X;
drop view CMPBusinessTreeShortcut_X;
drop view CMPCatalog_X;
drop view CMPBaseCapture_X;
drop view CMPCaptureRelation_X;
drop view CMPCaptureSpec_X;
drop view CMPCDCAttributeUsage_X;
drop view CMPChangeLog_X;
drop view CMPChangeSpec_X;
drop view CMPExtRelationalCapture_X;
drop view CMPExtStreamsCapture_X;
drop view CMPRelationalCapture_X;
drop view CMPStreamsCapture_X;
drop view CMPWBCaptureAttributeUsage_X;
drop view CMPWBRowIDUsage_X;
drop view CMPWBTxnIDUsage_X;
drop view CMPDatatype_X;
drop view CMPLanguage_X;
drop view CFA_X;
drop view CFAOwner_X;
drop view ComponentUnit_X;
drop view FirstClassObject_X;
drop view Folder_X;
drop view OWBClone_X;
drop view SecondClassObject_X;
drop view CMPConfigurable_X;
drop view CMPGenerationResult_X;
drop view CMPNamedConfiguration_X;
drop view CMPNamedConfigurationUsage_X;
drop view CMPPhysicalObject_X;
drop view CMPAggregationSpecification_X;
drop view CMPAggSpecUsage_X;
drop view CMPCompositeDimension_X;
drop view CMPCompositeDimensionUsage_X;
drop view CMPCube_X;
drop view CMPCubeDefAggrMethod_X;
drop view CMPCubeDimReference_X;
drop view CMPCubeMeasure_X;
drop view CMPMeasureFolder_X;
drop view CMPMeasureFolderReference_X;
drop view CMPMeasureFolderRefItem_X;
drop view CMPMeasureReference_X;
drop view CMPDMModel_X;
drop view CMPDerivationSchema_X;
drop view CMPFunctionalDependency_X;
drop view CMPInclusionDependency_X;
drop view CMPMultiObjectHolder_X;
drop view CMPProfile_X;
drop view CMPProfileAttribute_X;
drop view CMPProfileForeignKey_X;
drop view CMPProfileObject_X;
drop view CMPProfileTable_X;
drop view CMPProfileUniqueKey_X;
drop view CMPRdntItemSet_X;
drop view CMPRdntItemSetUsage_X;
drop view CMPTargetTableUsage_X;
drop view CMPTargetUsage_X;
drop view CMPDependency_X;
drop view CMPDerivationSourceFCO_X;
drop view CMPDerivationSourceReference_X;
drop view CMPDerivationSourceSCO_X;
drop view CMPDerivedFCO_X;
drop view CMPDerivedSCO_X;
drop view CMPDerivationLink_X;
drop view CMPDerivationSet_X;
drop view CMPDimension_X;
drop view CMPDimensionAttribute_X;
drop view CMPDimensionRole_X;
drop view CMPHierarchy_X;
drop view CMPHierarchyLevelUsage_X;
drop view CMPLevel_X;
drop view CMPLevelAttribute_X;
drop view CMPSkipLevelRelationship_X;
drop view CMPWBPsftTreeStrct_X;
drop view CMPAbstractType_X;
drop view CMPArrayType_X;
drop view CMPCollectionType_X;
drop view CMPDomain_X;
drop view CMPPrimitiveType_X;
drop view CMPRange_X;
drop view CMPScalarType_X;
drop view CMPLocation_X;
drop view CMPLocationUsage_X;
drop view CMPLogicalConnector_X;
drop view CMPLogicalLocation_X;
drop view CMPRuntimeLocation_X;
drop view CMPRecord_X;
drop view CMPWBField_X;
drop view CMPWBFile_X;
drop view CMPWBFormatMask_X;
drop view CMPCobolStructure_X;
drop view CMPDependentArray_X;
drop view CMPRedefines_X;
drop view CMPElement_X;
drop view CMPInstallation_X;
drop view CMPSupportedLanguage_X;
drop view CMPFunction_X;
drop view CMPFunctionArgument_X;
drop view CMPFunctionCategory_X;
drop view CMPFunctionImplementation_X;
drop view CMPFunctionParallel_X;
drop view CMPPLSCollection_X;
drop view CMPPLSRecord_X;
drop view CMPPLSRowtype_X;
drop view CMPRecordFieldUsage_X;
drop view CMPRefCursorType_X;
drop view CMPSoftwareModule_X;
drop view CMPWBApplicationType_X;
drop view CMPWBDSIntegratorMap_X;
drop view CMPWBIntegrator_X;
drop view CMPWBIntgACETypeUsage_X;
drop view CMPWBSystemType_X;
drop view CMPWBValidDataTypeList_X;
drop view CMPIntellBusAreaShortcut_X;
drop view CMPIntelligenceBusArea_X;
drop view CMPIntelligenceBusAreaFCO_X;
drop view CMPIntelligenceSchema_X;
drop view CMPAttribute_X;
drop view CMPAttributeArray_X;
drop view CMPComplexItem_X;
drop view CMPExpressionOwner_X;
drop view CMPExpressionVariable_X;
drop view CMPExternalTableItem_X;
drop view CMPFlexField_X;
drop view CMPFlexStructure_X;
drop view CMPForeignKey_X;
drop view CMPItem_X;
drop view CMPItemSet_X;
drop view CMPOrderedObject_X;
drop view CMPRelationalDBItem_X;
drop view CMPStreamsSubstituteKey_X;
drop view CMPStructure_X;
drop view CMPUnion_X;
drop view CMPUniqueKey_X;
drop view CMPWBCheckConstraint_X;
drop view CMPWBItemSetUsage_X;
drop view CMPWBNamedItemSet_X;
drop view CMPBaseEmbedMap_X;
drop view CMPBaseMap_X;
drop view CMPBaseMapOperator_X;
drop view CMPEmbedMap_X;
drop view CMPEmbedMapOwner_X;
drop view CMPMap_X;
drop view CMPMapAttribute_X;
drop view CMPMapAttributeBindee_X;
drop view CMPMapAttributeGroup_X;
drop view CMPMapAttributeGroupBindee_X;
drop view CMPMapAttributeGroupOwner_X;
drop view CMPMapDisplaySet_X;
drop view CMPMapDisplaySetBindee_X;
drop view CMPMapDisplaySetUsage_X;
drop view CMPMapOperator_X;
drop view CMPMapOperatorBindee_X;
drop view CMPMapOperatorOwner_X;
drop view CMPMapOperatorUsage_X;
drop view CMPMappable_X;
drop view CMPPublicSubMap_X;
drop view CMPSubMapLibrary_X;
drop view CMPACEType_X;
drop view CMPWBACETypeUsage_X;
drop view ClassUsageOwner_X;
drop view CMPArrayModelAttribute_X;
drop view CMPAssociationDefinition_X;
drop view CMPClassDefinition_X;
drop view CMPClassUsage_X;
drop view CMPClassUsageGroup_X;
drop view CMPCollectionModelAttribute_X;
drop view CMPDefinitionElement_X;
drop view CMPDependencyDefinition_X;
drop view CMPExtensionModel_X;
drop view CMPModelAttribute_X;
drop view CMPPrimitiveModelAttribute_X;
drop view CMPPropertyDefinition_X;
drop view CMPPropertyGroupDefinition_X;
drop view CMPPropertyGroupOwner_X;
drop view CMPReferenceModelAttribute_X;
drop view CMPRegistryEntry_X;
drop view CMPRegistryService_X;
drop view CMPRoleDefinition_X;
drop view CMPScalarModelAttribute_X;
drop view CMPTranslatedField_X;
drop view CMPWBMIVDefinition_X;
drop view CMPWBMIVView_X;
drop view CMPMLSTranslatable_X;
drop view CMPTranslation_X;
drop view CMPAccessControlledElement_X;
drop view CMPBaseProcess_X;
drop view CMPBaseProcessActivity_X;
drop view CMPProcActivParamCandidate_X;
drop view CMPProcess_X;
drop view CMPProcessActivity_X;
drop view CMPProcessActivityParameter_X;
drop view CMPProcessInstalledModule_X;
drop view CMPProcessPackage_X;
drop view CMPProcessTransition_X;
drop view CMPProgram_X;
drop view CMPProgramGroup_X;
drop view CMPSubProcess_X;
drop view CMPWBProject_X;
drop view CMPCLOBPropertyValue_X;
drop view CMPPropertyOwner_X;
drop view CMPPropertyValue_X;
drop view CMPPurePhysicalObject_X;
drop view CMPReferencePropertyValue_X;
drop view CMPStringPropertyValue_X;
drop view CMPUserDefinedProperty_X;
drop view CMPDateHierLevel_X;
drop view CMPDateHierTemplate_X;
drop view CMPDesignAttribute_X;
drop view CMPDesignReference_X;
drop view CMPDesignRelation_X;
drop view CMPDrillItem_X;
drop view CMPDrillLevel_X;
drop view CMPDrillPath_X;
drop view CMPDrillPathJoinUsage_X;
drop view CMPDrillPathSegment_X;
drop view CMPIntelligenceItem_X;
drop view CMPJoin_X;
drop view CMPJoinComponent_X;
drop view CMPLOVItemClass_X;
drop view CMPObjectJoinUsage_X;
drop view CMPQueryCondition_X;
drop view CMPQueryExpOwner_X;
drop view CMPQueryExpRef_X;
drop view CMPQueryItem_X;
drop view CMPQueryObject_X;
drop view CMPQueryReferencable_X;
drop view CMPAdvancedQueue_X;
drop view CMPConcreteTypeUsage_X;
drop view CMPQueuePropagation_X;
drop view CMPQueueTable_X;
drop view CMPStreamsApply_X;
drop view CMPStreamsApplyTableUsage_X;
drop view CMPStreamsDMLHandlerUsage_X;
drop view CMPCluster_X;
drop view CMPClusterUsage_X;
drop view CMPExternalTable_X;
drop view CMPIndex_X;
drop view CMPPartition_X;
drop view CMPPartitionKey_X;
drop view CMPTrigger_X;
drop view CMPWBMaterializedView_X;
drop view CMPWBSequence_X;
drop view CMPWBTable_X;
drop view CMPWBView_X;
drop view CMPReport_X;
drop view CMPReportItem_X;
drop view CMPReportGroup_X;
drop view CMPReportGroupShortcut_X;
drop view CMPReportSchema_X;
drop view CMPBaseCalendar_X;
drop view CMPCalendar_X;
drop view CMPCalendarInstalledModule_X;
drop view CMPCalendarUsage_X;
drop view CMPLocalCalendar_X;
drop view CMPTimeWindow_X;
drop view Schedulable_X;
drop view CMPAccessControlList_X;
drop view CMPAccessPreference_X;
drop view CMPACLContainer_X;
drop view CMPPrivilegeOwner_X;
drop view CMPRoleAssignment_X;
drop view CMPWBRole_X;
drop view CMPWBUser_X;
drop view CMPTask_X;
drop view CMPTaskFlow_X;
drop view CMPTaskFlowInstalledModule_X;
drop view CMPTaskFlowSet_X;
drop view CMPTaskFlowUsage_X;
drop view CMPTaskImplementation_X;
drop view CMPTaskInstruction_X;
drop view CMPWBOracleDatafile_X;
drop view CMPWBOracleTTS_X;
drop view CMPWBOracleTTSSet_X;
drop view CMPWBOracleTTSUsage_X;
drop view CMPAbstractCollection_X;
drop view CMPComplexDatatype_X;
drop view CMPObjectType_X;
drop view CMPRecordField_X;
drop view CMPReferenceDatatype_X;
drop view CMPSQLCollection_X;
drop view CMPTypeDefinition_X;
drop view CMPTypedObject_X;
drop view CMPValidationComponent_X;
drop view CMPWBValidationResult_X;
drop view CMPBaseVariable_X;
drop view CMPGlobalVariable_X;
drop view CMPVariable_X;
drop view CMPVariableFolder_X;
drop view CMPVariableOwner_X;
drop view CMPWeakAssociation_X;
drop view CMPWeakComponent_X;
drop view CMPWeakFirstClassObject_X;
drop view CMPWeakFolder_X;
drop view CMPWeakModule_X;
drop view CMPWeakSecondClassObject_X;
drop view WeakAssociationOwner_X;
drop view WeakComponentOwner_X;
drop view WeakFirstClassObjectOwner_X;
drop view WeakSecondClassObjectOwner_X;
drop view CMPWebAnalyticsProcessModule_X;
drop view CMPWeblogField_X;
drop view CMPWebLogFieldType_X;
drop view CMPWeblogFormat_X;
drop view CMPWeblogFormatType_X;
drop view CMPWeblogParseRule_X;
drop view CMPWeblogSource_X;
drop view CMPWebPageRule_X;
drop view CMPWebReferringSite_X;
drop view CMPWebResourceRule_X;
drop view CMPWebSearchEngine_X;
drop view CMPWebSessionRule_X;
drop view CMPWebsite_X;
drop view CMPWebsiteInstalledModule_X;
drop view CMPWebUserRule_X;
drop view CMPWebVisitorRule_X;
drop view CMPWebWarehouseModule_X;
drop view CMPWorkspace_X;
drop view CMPXMLAttribute_X;
drop view CMPXMLElement_X;
drop view CMPXMLFile_X;
drop view CMPXMLForeignKey_X;
drop view CMPXMLGroupType_X;
drop view CMPXMLSimpleType_X;
drop view CMPXMLUniqueKey_X;
drop view pctree_x ; 
drop view interlink_x ; 
drop view intralink_x ;