rem Generated for Warehouse Builder by UML Code Generator

drop sequence cwmseq;
drop table CMPFCOClasses cascade constraints;

drop table CMPMMMClasses cascade constraints;

drop table CMPSCOClasses cascade constraints;

drop table CMPSCOCfgClasses cascade constraints;

drop table CMPSCOMapClasses cascade constraints;

drop table CMPSCOPrpClasses cascade constraints;

drop table CMPSYSClasses cascade constraints;

drop view CMPRelation_V;
drop view CMPRelationalDBObject_V;
drop view CMPInstalledModule_V;
drop view CMPSharedInstalledModule_V;
drop view CMPWBDataWarehouse_V;
drop view CMPWBFileInstalledModule_V;
drop view CMPWBGatewayInstalledModule_V;
drop view CMPWBOracleInstalledModule_V;
drop view CMPWBPsftInstalledModule_V;
drop view CMPWBRepInstalledModule_V;
drop view CMPWBSAPInstalledModule_V;
drop view CMPXMLInstalledModule_V;
drop view CMPBinaryObject_V;
drop view CMPIcon_V;
drop view CMPBusinessRuleDefinition_V;
drop view CMPBusinessRuleItemParam_V;
drop view CMPBusinessRuleModule_V;
drop view CMPBusinessRuleRelParam_V;
drop view CMPBusinessRuleUsage_V;
drop view CMPDataRuleMap_V;
drop view CMPRelationUsage_V;
drop view CMPBusinessTreeShortcut_V;
drop view CMPCatalog_V;
drop view CMPBaseCapture_V;
drop view CMPCaptureRelation_V;
drop view CMPCaptureSpec_V;
drop view CMPCDCAttributeUsage_V;
drop view CMPChangeLog_V;
drop view CMPChangeSpec_V;
drop view CMPExtRelationalCapture_V;
drop view CMPExtStreamsCapture_V;
drop view CMPRelationalCapture_V;
drop view CMPStreamsCapture_V;
drop view CMPWBCaptureAttributeUsage_V;
drop view CMPWBRowIDUsage_V;
drop view CMPWBTxnIDUsage_V;
drop view CMPDatatype_V;
drop view CMPLanguage_V;
drop view CFA_V;
drop view CFAOwner_V;
drop view ComponentUnit_V;
drop view FirstClassObject_V;
drop view Folder_V;
drop view OWBClone_V;
drop view SecondClassObject_V;
drop view CMPConfigurable_V;
drop view CMPGenerationResult_V;
drop view CMPNamedConfiguration_V;
drop view CMPNamedConfigurationUsage_V;
drop view CMPPhysicalObject_V;
drop view CMPAggregationSpecification_V;
drop view CMPAggSpecUsage_V;
drop view CMPCompositeDimension_V;
drop view CMPCompositeDimensionUsage_V;
drop view CMPCube_V;
drop view CMPCubeDefAggrMethod_V;
drop view CMPCubeDimReference_V;
drop view CMPCubeMeasure_V;
drop view CMPMeasureFolder_V;
drop view CMPMeasureFolderReference_V;
drop view CMPMeasureFolderRefItem_V;
drop view CMPMeasureReference_V;
drop view CMPDMModel_V;
drop view CMPDerivationSchema_V;
drop view CMPFunctionalDependency_V;
drop view CMPInclusionDependency_V;
drop view CMPMultiObjectHolder_V;
drop view CMPProfile_V;
drop view CMPProfileAttribute_V;
drop view CMPProfileForeignKey_V;
drop view CMPProfileObject_V;
drop view CMPProfileTable_V;
drop view CMPProfileUniqueKey_V;
drop view CMPRdntItemSet_V;
drop view CMPRdntItemSetUsage_V;
drop view CMPTargetTableUsage_V;
drop view CMPTargetUsage_V;
drop view CMPDependency_V;
drop view CMPDerivationSourceFCO_V;
drop view CMPDerivationSourceReference_V;
drop view CMPDerivationSourceSCO_V;
drop view CMPDerivedFCO_V;
drop view CMPDerivedSCO_V;
drop view CMPDerivationLink_V;
drop view CMPDerivationSet_V;
drop view CMPDimension_V;
drop view CMPDimensionAttribute_V;
drop view CMPDimensionRole_V;
drop view CMPHierarchy_V;
drop view CMPHierarchyLevelUsage_V;
drop view CMPLevel_V;
drop view CMPLevelAttribute_V;
drop view CMPSkipLevelRelationship_V;
drop view CMPWBPsftTreeStrct_V;
drop view CMPAbstractType_V;
drop view CMPArrayType_V;
drop view CMPCollectionType_V;
drop view CMPDomain_V;
drop view CMPPrimitiveType_V;
drop view CMPRange_V;
drop view CMPScalarType_V;
drop view CMPLocation_V;
drop view CMPLocationUsage_V;
drop view CMPLogicalConnector_V;
drop view CMPLogicalLocation_V;
drop view CMPRuntimeLocation_V;
drop view CMPRecord_V;
drop view CMPWBField_V;
drop view CMPWBFile_V;
drop view CMPWBFormatMask_V;
drop view CMPCobolStructure_V;
drop view CMPDependentArray_V;
drop view CMPRedefines_V;
drop view CMPElement_V;
drop view CMPInstallation_V;
drop view CMPSupportedLanguage_V;
drop view CMPFunction_V;
drop view CMPFunctionArgument_V;
drop view CMPFunctionCategory_V;
drop view CMPFunctionImplementation_V;
drop view CMPFunctionParallel_V;
drop view CMPPLSCollection_V;
drop view CMPPLSRecord_V;
drop view CMPPLSRowtype_V;
drop view CMPRecordFieldUsage_V;
drop view CMPRefCursorType_V;
drop view CMPSoftwareModule_V;
drop view CMPWBApplicationType_V;
drop view CMPWBDSIntegratorMap_V;
drop view CMPWBIntegrator_V;
drop view CMPWBIntgACETypeUsage_V;
drop view CMPWBSystemType_V;
drop view CMPWBValidDataTypeList_V;
drop view CMPIntellBusAreaShortcut_V;
drop view CMPIntelligenceBusArea_V;
drop view CMPIntelligenceBusAreaFCO_V;
drop view CMPIntelligenceSchema_V;
drop view CMPAttribute_V;
drop view CMPAttributeArray_V;
drop view CMPComplexItem_V;
drop view CMPExpressionOwner_V;
drop view CMPExpressionVariable_V;
drop view CMPExternalTableItem_V;
drop view CMPFlexField_V;
drop view CMPFlexStructure_V;
drop view CMPForeignKey_V;
drop view CMPItem_V;
drop view CMPItemSet_V;
drop view CMPOrderedObject_V;
drop view CMPRelationalDBItem_V;
drop view CMPStreamsSubstituteKey_V;
drop view CMPStructure_V;
drop view CMPUnion_V;
drop view CMPUniqueKey_V;
drop view CMPWBCheckConstraint_V;
drop view CMPWBItemSetUsage_V;
drop view CMPWBNamedItemSet_V;
drop view CMPBaseEmbedMap_V;
drop view CMPBaseMap_V;
drop view CMPBaseMapOperator_V;
drop view CMPEmbedMap_V;
drop view CMPEmbedMapOwner_V;
drop view CMPMap_V;
drop view CMPMapAttribute_V;
drop view CMPMapAttributeBindee_V;
drop view CMPMapAttributeGroup_V;
drop view CMPMapAttributeGroupBindee_V;
drop view CMPMapAttributeGroupOwner_V;
drop view CMPMapDisplaySet_V;
drop view CMPMapDisplaySetBindee_V;
drop view CMPMapDisplaySetUsage_V;
drop view CMPMapOperator_V;
drop view CMPMapOperatorBindee_V;
drop view CMPMapOperatorOwner_V;
drop view CMPMapOperatorUsage_V;
drop view CMPMappable_V;
drop view CMPPublicSubMap_V;
drop view CMPSubMapLibrary_V;
drop view CMPACEType_V;
drop view CMPWBACETypeUsage_V;
drop view ClassUsageOwner_V;
drop view CMPArrayModelAttribute_V;
drop view CMPAssociationDefinition_V;
drop view CMPClassDefinition_V;
drop view CMPClassUsage_V;
drop view CMPClassUsageGroup_V;
drop view CMPCollectionModelAttribute_V;
drop view CMPDefinitionElement_V;
drop view CMPDependencyDefinition_V;
drop view CMPExtensionModel_V;
drop view CMPModelAttribute_V;
drop view CMPPrimitiveModelAttribute_V;
drop view CMPPropertyDefinition_V;
drop view CMPPropertyGroupDefinition_V;
drop view CMPPropertyGroupOwner_V;
drop view CMPReferenceModelAttribute_V;
drop view CMPRegistryEntry_V;
drop view CMPRegistryService_V;
drop view CMPRoleDefinition_V;
drop view CMPScalarModelAttribute_V;
drop view CMPTranslatedField_V;
drop view CMPWBMIVDefinition_V;
drop view CMPWBMIVView_V;
drop view CMPMLSTranslatable_V;
drop view CMPTranslation_V;
drop view CMPAccessControlledElement_V;
drop view CMPBaseProcess_V;
drop view CMPBaseProcessActivity_V;
drop view CMPProcActivParamCandidate_V;
drop view CMPProcess_V;
drop view CMPProcessActivity_V;
drop view CMPProcessActivityParameter_V;
drop view CMPProcessInstalledModule_V;
drop view CMPProcessPackage_V;
drop view CMPProcessTransition_V;
drop view CMPProgram_V;
drop view CMPProgramGroup_V;
drop view CMPSubProcess_V;
drop view CMPWBProject_V;
drop view CMPCLOBPropertyValue_V;
drop view CMPPropertyOwner_V;
drop view CMPPropertyValue_V;
drop view CMPPurePhysicalObject_V;
drop view CMPReferencePropertyValue_V;
drop view CMPStringPropertyValue_V;
drop view CMPUserDefinedProperty_V;
drop view CMPDateHierLevel_V;
drop view CMPDateHierTemplate_V;
drop view CMPDesignAttribute_V;
drop view CMPDesignReference_V;
drop view CMPDesignRelation_V;
drop view CMPDrillItem_V;
drop view CMPDrillLevel_V;
drop view CMPDrillPath_V;
drop view CMPDrillPathJoinUsage_V;
drop view CMPDrillPathSegment_V;
drop view CMPIntelligenceItem_V;
drop view CMPJoin_V;
drop view CMPJoinComponent_V;
drop view CMPLOVItemClass_V;
drop view CMPObjectJoinUsage_V;
drop view CMPQueryCondition_V;
drop view CMPQueryExpOwner_V;
drop view CMPQueryExpRef_V;
drop view CMPQueryItem_V;
drop view CMPQueryObject_V;
drop view CMPQueryReferencable_V;
drop view CMPAdvancedQueue_V;
drop view CMPConcreteTypeUsage_V;
drop view CMPQueuePropagation_V;
drop view CMPQueueTable_V;
drop view CMPStreamsApply_V;
drop view CMPStreamsApplyTableUsage_V;
drop view CMPStreamsDMLHandlerUsage_V;
drop view CMPCluster_V;
drop view CMPClusterUsage_V;
drop view CMPExternalTable_V;
drop view CMPIndex_V;
drop view CMPPartition_V;
drop view CMPPartitionKey_V;
drop view CMPTrigger_V;
drop view CMPWBMaterializedView_V;
drop view CMPWBSequence_V;
drop view CMPWBTable_V;
drop view CMPWBView_V;
drop view CMPReport_V;
drop view CMPReportItem_V;
drop view CMPReportGroup_V;
drop view CMPReportGroupShortcut_V;
drop view CMPReportSchema_V;
drop view CMPBaseCalendar_V;
drop view CMPCalendar_V;
drop view CMPCalendarInstalledModule_V;
drop view CMPCalendarUsage_V;
drop view CMPLocalCalendar_V;
drop view CMPTimeWindow_V;
drop view Schedulable_V;
drop view CMPAccessControlList_V;
drop view CMPAccessPreference_V;
drop view CMPACLContainer_V;
drop view CMPPrivilegeOwner_V;
drop view CMPRoleAssignment_V;
drop view CMPWBRole_V;
drop view CMPWBUser_V;
drop view CMPTask_V;
drop view CMPTaskFlow_V;
drop view CMPTaskFlowInstalledModule_V;
drop view CMPTaskFlowSet_V;
drop view CMPTaskFlowUsage_V;
drop view CMPTaskImplementation_V;
drop view CMPTaskInstruction_V;
drop view CMPWBOracleDatafile_V;
drop view CMPWBOracleTTS_V;
drop view CMPWBOracleTTSSet_V;
drop view CMPWBOracleTTSUsage_V;
drop view CMPAbstractCollection_V;
drop view CMPComplexDatatype_V;
drop view CMPObjectType_V;
drop view CMPRecordField_V;
drop view CMPReferenceDatatype_V;
drop view CMPSQLCollection_V;
drop view CMPTypeDefinition_V;
drop view CMPTypedObject_V;
drop view CMPValidationComponent_V;
drop view CMPWBValidationResult_V;
drop view CMPBaseVariable_V;
drop view CMPGlobalVariable_V;
drop view CMPVariable_V;
drop view CMPVariableFolder_V;
drop view CMPVariableOwner_V;
drop view CMPWeakAssociation_V;
drop view CMPWeakComponent_V;
drop view CMPWeakFirstClassObject_V;
drop view CMPWeakFolder_V;
drop view CMPWeakModule_V;
drop view CMPWeakSecondClassObject_V;
drop view WeakAssociationOwner_V;
drop view WeakComponentOwner_V;
drop view WeakFirstClassObjectOwner_V;
drop view WeakSecondClassObjectOwner_V;
drop view CMPWebAnalyticsProcessModule_V;
drop view CMPWeblogField_V;
drop view CMPWebLogFieldType_V;
drop view CMPWeblogFormat_V;
drop view CMPWeblogFormatType_V;
drop view CMPWeblogParseRule_V;
drop view CMPWeblogSource_V;
drop view CMPWebPageRule_V;
drop view CMPWebReferringSite_V;
drop view CMPWebResourceRule_V;
drop view CMPWebSearchEngine_V;
drop view CMPWebSessionRule_V;
drop view CMPWebsite_V;
drop view CMPWebsiteInstalledModule_V;
drop view CMPWebUserRule_V;
drop view CMPWebVisitorRule_V;
drop view CMPWebWarehouseModule_V;
drop view CMPWorkspace_V;
drop view CMPXMLAttribute_V;
drop view CMPXMLElement_V;
drop view CMPXMLFile_V;
drop view CMPXMLForeignKey_V;
drop view CMPXMLGroupType_V;
drop view CMPXMLSimpleType_V;
drop view CMPXMLUniqueKey_V;
drop view pctree_v ; 
drop view interlink_v ; 
drop view intralink_v ; 
drop table MCMModelSemantics cascade constraints; 

Rem 10/18/2007 epaglina drop view were missing for tokyo
Rem Added for Repos Upgrade Feature

drop view CMPALLWBUSER_V;
drop view CMPFCOELEMENT_V;
drop view CMPFCOELEMENT_X;
drop view CMPFCORELATION_V;
drop view CMPFCORELATION_X;
drop view CMPSCOCFGELEMENT_V;
drop view CMPSCOCFGELEMENT_X;
drop view CMPSCOCFGRELATION_V;
drop view CMPSCOCFGRELATION_X;
drop view CMPSCOELEMENT_V;
drop view CMPSCOELEMENT_X;
drop view CMPSCOMAPELEMENT_V;
drop view CMPSCOMAPELEMENT_X;
drop view CMPSCOPRPELEMENT_V;
drop view CMPSCOPRPELEMENT_X;
drop view CMPSYSELEMENT_V;
drop view CMPSYSELEMENT_X;