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 CMPDatabaseModule_V;
drop view CMPInstalledModule_V;
drop view CMPSharedInstalledModule_V;
drop view CMPWBFileInstalledModule_V;
drop view CMPWBRepInstalledModule_V;
drop view CMPWBSAPInstalledModule_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 CMPDatatype_V;
drop view CMPLanguage_V;
drop view CMPPlatformMappingSet_V;
drop view CMPPlatformTypeSet_V;
drop view CMPTypeMapping_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 CMPPlatformConfiguration_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 CMPDerivationSchema_V;
drop view CMPFunctionalDependency_V;
drop view CMPInclusionDependency_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 CMPDataService_V;
drop view CMPKMExecUnit_V;
drop view CMPKMExecUnitParam_V;
drop view CMPDependency_V;
drop view CMPDerivationSourceFCO_V;
drop view CMPDerivationSourceSCO_V;
drop view CMPDerivedFCO_V;
drop view CMPDerivedSCO_V;
drop view CMPDerivationLink_V;
drop view CMPDerivationSet_V;
drop view CMPDiagram_V;
drop view CMPDiagramComponent_V;
drop view CMPDiagramComponentOwner_V;
drop view CMPDiagramElement_V;
drop view CMPDiagramFolder_V;
drop view CMPDiagramNode_V;
drop view CMPDiagramOwner_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 CMPAbstractType_V;
drop view CMPAnonymousDomain_V;
drop view CMPArrayType_V;
drop view CMPCollectionType_V;
drop view CMPDomain_V;
drop view CMPNamedDomain_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 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 CMPIntellBusAreaShortcut_V;
drop view CMPIntelligenceBusArea_V;
drop view CMPIntelligenceBusAreaFCO_V;
drop view CMPIntelligenceSchema_V;
drop view CMPAttribute_V;
drop view CMPExpressionOwner_V;
drop view CMPExpressionVariable_V;
drop view CMPExternalTableItem_V;
drop view CMPForeignKey_V;
drop view CMPItem_V;
drop view CMPItemSet_V;
drop view CMPOrderedObject_V;
drop view CMPRelationalDBItem_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 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 CMPMapExecutionUnit_V;
drop view CMPMapExecutionUnitParameter_V;
drop view CMPMapExecutionUnitUsage_V;
drop view CMPMapOperator_V;
drop view CMPMapOperatorBindee_V;
drop view CMPMapOperatorOwner_V;
drop view CMPMappable_V;
drop view CMPMapTaskFlowUsage_V;
drop view CMPPhysicalMap_V;
drop view CMPPublicSubMap_V;
drop view CMPSubMapLibrary_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 CMPModelAttribute_V;
drop view CMPModelDefinition_V;
drop view CMPModelOwner_V;
drop view CMPPrimitiveModelAttribute_V;
drop view CMPPropertyDefinition_V;
drop view CMPPropertyGroupDefinition_V;
drop view CMPPropertyGroupOwner_V;
drop view CMPPropertySetDefinition_V;
drop view CMPRoleDefinition_V;
drop view CMPScalarModelAttribute_V;
drop view CMPWBMIVDefinition_V;
drop view CMPWBMIVView_V;
drop view CMPMLSTranslatable_V;
drop view CMPTranslation_V;
drop view CMPDefaultKMUsage_V;
drop view CMPModelUsage_V;
drop view CMPPlatform_V;
drop view CMPPlatformConfigTemplate_V;
drop view CMPUserConfigTemplateSet_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 CMPDesignAttribute_V;
drop view CMPDesignReference_V;
drop view CMPDesignRelation_V;
drop view CMPDrillItem_V;
drop view CMPDrillLevel_V;
drop view CMPDrillLevelKey_V;
drop view CMPDrillLevelKeyUsage_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 CMPQueryAggregationLevel_V;
drop view CMPQueryCondition_V;
drop view CMPQueryDBObjectUsage_V;
drop view CMPQueryExpOwner_V;
drop view CMPQueryExpRef_V;
drop view CMPQueryForeignKeyUsage_V;
drop view CMPQueryItem_V;
drop view CMPQueryObject_V;
drop view CMPQueryReferencable_V;
drop view CMPAdvancedQueue_V;
drop view CMPQueuePropagation_V;
drop view CMPQueueTable_V;
drop view CMPExternalTable_V;
drop view CMPIndex_V;
drop view CMPPartition_V;
drop view CMPPartitionKey_V;
drop view CMPWBMaterializedView_V;
drop view CMPWBSequence_V;
drop view CMPWBTable_V;
drop view CMPWBView_V;
drop view CMPBaseCalendar_V;
drop view CMPCalendar_V;
drop view CMPCalendarInstalledModule_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 CMPFCOFolderReference_V;
drop view CMPUserFolder_V;
drop view CMPValidationComponent_V;
drop view CMPWBValidationResult_V;
drop view CMPBaseVariable_V;
drop view CMPVariable_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 CMPAppServerInstalledModule_V;
drop view CMPWebService_V;
drop view CMPWebServicePackage_V;
drop view CMPWorkspace_V;
drop view pctree_v ; 
drop view interlink_v ; 
drop view intralink_v ; 
drop tableMCMModelSemantics cascade constraints;