Script to Remove Workflow Tables from Article List for Plant Applications 6.2

You can use the following script to remove Workflow tables from the local publication of the Plant Applications database. Run the script in SQL Server Management Studio, pointing to the corresponding replicated database.
Important:
  • This script is applicable only for Plant Applications 6.2.
  • 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.
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