Script to Remove Workflow Tables from Article List for Plant Applications 7.0
You can use the following script to remove Workflow tables from the local
publication of the Plant Applications database.
Important:
- This script is applicable only for Plant Applications 7.0.
- In this script, angle brackets (< >) indicate placeholder text. You must replace the placeholder text with an appropriate value before running the script.
- In this script, the publication name specified is SampleRepl. Replace it with the correct publication name.
- The script does not specify the database name as SOADB. Therefore, you must use this script on an SOADB database.
- After running the script, if an error message appears, stating that the object does not exist, ignore it.
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'ActiveDirectoryChildGroup',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'ActiveDirectoryGroup',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'ActualProp_EquipmentActual',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'ActualProp_MaterialActual',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'ActualProp_PersonnelActual',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'ADGroupAndChildGroup',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'ADGroupAndPersonnel',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'AssemblyDefinition',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'AuditRecord',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'AuditTopicConfig',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'AuthenticationControlSettings',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'BinaryItem',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'CategoryAssociation_CompletionCodeDefinition',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'CategoryAssociation_FaultDefinition',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'CategoryAssociation_SubProcessDefinition',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'CategoryAssociation_UserActivityDefinition',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'CategoryAssociation_WorkflowDefinition',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'CategoryAssociation_WorkflowSchedule',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'CategoryDefinition',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'ClientUIElementDmc',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'CompletionCodeDefinition',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'ComponentModule',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'ComponentModuleDependency',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'ComponentProject',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'ComputerDmc',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'ComputerFilterAssignments',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'ConditionEventDefinition',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'ConfigPanelMethod',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'Counter',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'DashboardLayout',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'DashboardLayoutPage',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'DashboardPage',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'DatabaseConnection',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'DatabaseStatement',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'DatabaseStatementParameter',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'DataModelInfo',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'DataTypeCustomEditorDmfc',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'DefaultClientLayoutDmc',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'DeletedDesignerReferenceDmc',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'DisplayDmc',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'DisplayHierarchyDmc',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'DtlNode',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'ElectronicSignature',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'Email_Server',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'EqActualPropTemplate',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'Equipment',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'EquipmentActual',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'EquipmentClass',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'EquipmentClass_EquipmentObject',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'EquipmentPropertyHistory',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'EquipmentProvisioning',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'EquipmentProvisioningResults',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'EquipmentSpec_ProcSeg',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'EquipmentSpec_ProdSeg',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'EquipmentSpec_SegReq',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'eSop_ConfigPanel',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'eSop_Jump',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'eSop_Keyword',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'eSop_LinkedDocument',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'eSop_ScheduleLookup',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'eSop_StepConfigPanel',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'eSop_StepEmail',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'eSop_StepEmailRecipient',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'eSop_Task',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'eSop_TaskConfigPanel',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'eSop_TaskConfigPanelData',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'eSop_TaskEmail',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'eSop_TaskEmailRecipient',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'eSop_TaskStep',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'eSop_TaskStepConfigPanelData',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'eSop_TaskStepTemplate',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'eSop_TaskTemplate',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'eSop_TaskTemplateMetadata',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'EventHistory',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'EventHistoryRecord_EventPropertyDefinition',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'EventPropertyDefinition',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'EventsDmfc',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'ExpiryDefinition_StepDefinition_WorkflowDefinition',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'ExpiryDefinition_StepDefinition_WorkflowSchedule',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'ExpiryDefinition_WorkflowDefinition',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'ExpiryDefinition_WorkflowSchedule',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'ExpressionDetails',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'ExpressionVariable',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'ExpressionVariableDefinition',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'ExtensionData',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'FaultDefinition',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'FragmentEquipmentInstanceAssociation',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'GlobalVariable',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'HasQueries_DisplayHierarchyDmc',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'HasQueries_LensDmc',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'HasQueries_SolutionDmc',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'Historian_Collector',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'Historian_Server',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'Historian_Tag',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'ITModelObject',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'ITModelObjectAspect',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'LegacyServiceAttributes',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'LensDmc',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'LinkedDocument_StepDefinition_WorkflowDefinition',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'LinkedDocument_StepDefinition_WorkflowSchedule',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'LinkedDocument_WorkflowDefinition',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'LinkedDocument_WorkflowSchedule',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'LinkedDocumentInstance_TaskStepInstance',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'LocalizedString',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'MatActualPropTemplate',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'MaterialActual',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'MaterialClass',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'MaterialClass_MaterialDefinition',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'MaterialDefinition',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'MaterialLot',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'MaterialLotAssembly',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'MaterialLotProperty',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'MaterialSpec_ProcSeg',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'MaterialSpec_ProdSeg',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'MaterialSpec_SegReq',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'MaterialSublot',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'ObjectAddress',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'OldestDiscardedDataChange',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'OpcGroup',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'OpcItem',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'OpcServer',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'OperationsMaterialBill',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'OperationsMaterialBillItem',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'PackageInfo',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'ParametersDmfc',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'PerActualPropTemplate',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'PersistenceRecord',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'Person',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'PersonEquipmentContext',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'PersonnelActual',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'PersonnelClaims',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'PersonnelClass',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'PersonnelClass_Person',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'PersonnelLocation',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'PersonnelRole',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'PersonnelSpec_ProcSeg',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'PersonnelSpec_ProdSeg',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'PersonnelSpec_SegReq',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'Portal_DataItem',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'Portal_DataSource',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'Portal_Display',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'Portal_Server',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'Portal_Statement',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'ProcessSegment_SegmentParameter',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'ProcessSegmentAndWorkDataClass',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'ProcSeg',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'ProdSeg',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'Producer',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'ProducerConnection',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'ProducerDataPoint',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'ProductApplicationData',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'ProductOption',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'ProductOptionContent',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'ProductOptionContentFile',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'ProductOptionServices',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'ProductSegment_SegmentParameter',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'ProductSegmentLevel',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'ProductToProcess',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'ProductUserData',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'ProficyProduct',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'ProjectContent',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'ProjectInfo',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'Property_Equipment_EquipmentClass',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'Property_EquipmentClass',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'Property_MaterialClass',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'Property_MaterialDefinition_MaterialClass',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'Property_Person_PersonnelClass',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'Property_PersonnelClass',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'PropertyGroup',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'PropertyGroupProperties',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'QueryDmc',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'ReportingSchedule',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'RequestMaterialBill',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'RequestMaterialBillItem',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'ResourceClaims',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'ResourceClaimsAndPrivileges',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'RevisionInfo',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'RoleAndPrivileges',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'SchemaVersion',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'SegmentIsComposedOf_ProcSeg',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'SegmentIsComposedOf_ProdSeg',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'SegmentIsComposedOf_SegReq',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'SegmentParameter',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'SegmentRequirement_SegmentParameter',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'SegmentResponse',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'SegmentResponseWorkDataClass',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'SegmentSpecification',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'SegReq',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'ServerInstance',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'ServiceContainer',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'ServiceDeployment',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'ServiceDeploymentUnit',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'ServiceInterface',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'ServiceNamespace',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'ServiceProvider',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'ServiceProviderContainer',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'ServiceProviderLicense',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'SolutionDmc',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'SolutionLensDisplayDmc',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'SolutionLensDmc',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'SpecEquipment_EquipmentSpec_ProcSeg',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'SpecEquipment_EquipmentSpec_ProdSeg',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'SpecEquipment_EquipmentSpec_SegReq',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'SpecEquipment_SyncEquipment_ProductToProcess_ProdSeg_ProcSeg',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'SpecMaterial_MaterialSpec_ProcSeg',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'SpecMaterial_MaterialSpec_ProdSeg',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'SpecMaterial_MaterialSpec_SegReq',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'SpecMaterial_SyncMaterial_ProductToProcess_ProdSeg_ProcSeg',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'SpecPersonnel_PersonnelSpec_ProcSeg',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'SpecPersonnel_PersonnelSpec_ProdSeg',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'SpecPersonnel_PersonnelSpec_SegReq',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'SpecPersonnel_SyncPersonnel_ProductToProcess_ProdSeg_ProcSeg',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'SpecProp_MaterialSpec_ProcSeg',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'SpecProp_MaterialSpec_ProdSeg',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'SpecProp_MaterialSpec_SegReq',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'StepDefinition_WorkflowDefinition',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'StepDefinition_WorkflowSchedule',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'StoredAssembly',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'StoredImageDmc',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'StructuredType',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'StructuredTypeProperty',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'SubProcessDefinition',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'SyncEquipment_ProductToProcess_ProdSeg_ProcSeg',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'SyncMaterial_ProductToProcess_ProdSeg_ProcSeg',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'SyncParameter_ProductToProcess_ProdSeg_ProcSeg',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'SyncPersonnel_ProductToProcess_ProdSeg_ProcSeg',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'TaskInstance',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'TaskInstanceData',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'TaskListVisibilityIT',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'TaskListVisibilityPersonnel',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'TaskStepDisplay',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'TaskStepInstance',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'TaskStepInstanceData',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'TimeEvent',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'TrackedVariable_StepDefinition_WorkflowDefinition',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'TrackedVariable_StepDefinition_WorkflowSchedule',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'TrackedVariable_WorkflowDefinition',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'TrackedVariable_WorkflowSchedule',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'TypeDefinition',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'UnacknowledgedDataChangePacket',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'UnsentDataChange',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'UrlRedirection',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'UserAccount',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'UserActivityDefinition',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'UserContextDmc',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'UserOverrideLayoutDmc',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'VariableDefinition_StepDefinition_WorkflowDefinition',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'VariableDefinition_StepDefinition_WorkflowSchedule',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'VariableDefinition_SubProcessDefinition',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'VariableDefinition_UserActivityDefinition',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'VariableDefinition_WorkflowDefinition',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'WeakRelation',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'WebService',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'WebServiceEndpointSecurity',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'WorkData',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'WorkDataClass',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'WorkDataClass_WorkDataProperty',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'WorkDataProperty',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'WorkDefinition',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'WorkflowDefinition',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'WorkflowInstance',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'WorkflowPendingImport',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'WorkflowResourceLink',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'WorkflowSchedule',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'WorkflowScheduleParameterValue',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'WorkInstructions',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'WorkInstructionsKeyword',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'WorkRequest',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'WorkResponse',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'GroupAndPerson',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'PersonAndGroup',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'PersonnelGroup',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'PersonnelPrivileges',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = '',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'EquipmentProvisioning ',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'EquipmentProvisioningResults',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'Fields',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'Fields_CheckBox',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'Fields_ComboBox',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'Fields_Image',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'Fields_Input',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'Fields_ListBox',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'Fields_RadioGroup',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'Fields_Selection',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'Fields_Text',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'Fields_TextArea',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'Fields_TextBox',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'Values',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'AppliedPredefinedFilters',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'FilterCriteria',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'FilterCriteriaCategory',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'FilterCriteriaComputer',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'FilterCriteriaInstance',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'FilterCriteriaPerson',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'FilterCriteriaPersonnelClass',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'InstanceFilterAssignments',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'PersonalFilters',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'PersonFilterAssignments',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'PersonnelClassFilterAssignments',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'InstanceFilterAssignments',@force_invalidate_snapshot = 1;
GO
EXEC sp_droparticle @publication = 'SampleRepl', @article = 'QuickFilters',@force_invalidate_snapshot = 1;
GO