How to Page?

 

Topic: Correct order to Drop Ephesoft Database Tables

Applicable Ephesoft versions: 3.x

If you need to drop the Ephesoft tables and recreate them, we suggest doing it in this order

 

Instructions:

 

  1. –This is for MS SQL
    1. EXEC sp_MSForEachTable ‘ALTER TABLE ? NOCHECK CONSTRAINT ALL’
      GO
      DROP TABLE module_plugin;
      DROP TABLE advanced_kv_extraction;
      DROP TABLE page_type;
      DROP TABLE batch_class;
      DROP TABLE plugin;
      DROP TABLE batch_class_cloud_config;
      DROP TABLE plugin_config;
      DROP TABLE batch_class_cmis_configuration;
      DROP TABLE batch_class_dynamic_plugin_config;
      DROP TABLE plugin_config_sample_value;
      DROP TABLE batch_class_email_configuration;
      DROP TABLE plugin_dependency;
      DROP TABLE batch_class_field;
      DROP TABLE regex_group;
      DROP TABLE batch_class_groups;
      DROP TABLE regex_pattern;
      DROP TABLE batch_class_module;
      DROP TABLE us_invoice;
      DROP TABLE regex_validation;
      DROP TABLE batch_class_module_config;
      DROP TABLE remote_batch_instance;
      DROP TABLE batch_class_plugin;
      DROP TABLE role;
      DROP TABLE us_invoice_data;
      DROP TABLE batch_class_plugin_config;
      DROP TABLE scanner_master_config_sample_value;
      DROP TABLE batch_class_scanner_configuration;
      DROP TABLE scanner_master_configuration;
      DROP TABLE application_checklist;
      DROP TABLE batch_instance;
      DROP TABLE security_group;
      DROP TABLE batch_instance_error_details;
      DROP TABLE vFBValidation;
      DROP TABLE security_user;
      DROP TABLE batch_instance_groups;
      DROP TABLE security_user_group;
      DROP TABLE batch_instance_retries;
      DROP TABLE server_registry;
      DROP TABLE service_status;
      DROP TABLE document_type;
      DROP TABLE table_columns_info;
      DROP TABLE email_data;
      DROP TABLE table_info;
      DROP TABLE field_type;
      DROP TABLE table_rule;
      DROP TABLE user_information;
      DROP TABLE function_key;
      DROP TABLE hist_manual_steps_in_workflow;
      DROP TABLE kv_extraction;
      DROP TABLE kv_page_process;
      DROP TABLE module_config;
      DROP TABLE module;
      DROP TABLE lock_status;
      DROP TABLE JBPM4_VARIABLE;
      DROP TABLE JBPM4_DEPLOYMENT;
      DROP TABLE JBPM4_DEPLOYPROP;
      DROP TABLE JBPM4_EXECUTION;
      DROP TABLE JBPM4_HIST_VAR;
      DROP TABLE JBPM4_HIST_DETAIL;
      DROP TABLE JBPM4_HIST_PROCINST;
      DROP TABLE JBPM4_HIST_ACTINST;
      DROP TABLE JBPM4_HIST_TASK;
      DROP TABLE JBPM4_SWIMLANE;
      DROP TABLE JBPM4_TASK;
      DROP TABLE JBPM4_PARTICIPATION;
      DROP TABLE JBPM4_PROPERTY;
      DROP TABLE JBPM4_LOB;
      DROP TABLE JBPM4_JOB;
      EXEC sp_MSForEachTable ‘ALTER TABLE ? CHECK CONSTRAINT ALL’
      GO
  2. — This is for MySQL
    1. SET foreign_key_checks = 0;
      DROP TABLE module_plugin;
      DROP TABLE advanced_kv_extraction;
      DROP TABLE page_type;
      DROP TABLE batch_class;
      DROP TABLE plugin;
      DROP TABLE batch_class_cloud_config;
      DROP TABLE plugin_config;
      DROP TABLE batch_class_cmis_configuration;
      DROP TABLE batch_class_dynamic_plugin_config;
      DROP TABLE plugin_config_sample_value;
      DROP TABLE batch_class_email_configuration;
      DROP TABLE plugin_dependency;
      DROP TABLE batch_class_field;
      DROP TABLE regex_group;
      DROP TABLE batch_class_groups;
      DROP TABLE regex_pattern;
      DROP TABLE batch_class_module;
      DROP TABLE us_invoice;
      DROP TABLE regex_validation;
      DROP TABLE batch_class_module_config;
      DROP TABLE remote_batch_instance;
      DROP TABLE batch_class_plugin;
      DROP TABLE role;
      DROP TABLE us_invoice_data;
      DROP TABLE batch_class_plugin_config;
      DROP TABLE scanner_master_config_sample_value;
      DROP TABLE batch_class_scanner_configuration;
      DROP TABLE scanner_master_configuration;
      DROP TABLE application_checklist;
      DROP TABLE batch_instance;
      DROP TABLE security_group;
      DROP TABLE batch_instance_error_details;
      DROP TABLE vFBValidation;
      DROP TABLE security_user;
      DROP TABLE batch_instance_groups;
      DROP TABLE security_user_group;
      DROP TABLE batch_instance_retries;
      DROP TABLE server_registry;
      DROP TABLE service_status;
      DROP TABLE document_type;
      DROP TABLE table_columns_info;
      DROP TABLE email_data;
      DROP TABLE table_info;
      DROP TABLE field_type;
      DROP TABLE table_rule;
      DROP TABLE user_information;
      DROP TABLE function_key;
      DROP TABLE hist_manual_steps_in_workflow;
      DROP TABLE kv_extraction;
      DROP TABLE kv_page_process;
      DROP TABLE module_config;
      DROP TABLE module;
      DROP TABLE lock_status;
      DROP TABLE JBPM4_VARIABLE;
      DROP TABLE JBPM4_DEPLOYMENT;
      DROP TABLE JBPM4_DEPLOYPROP;
      DROP TABLE JBPM4_EXECUTION;
      DROP TABLE JBPM4_HIST_VAR;
      DROP TABLE JBPM4_HIST_DETAIL;
      DROP TABLE JBPM4_HIST_PROCINST;
      DROP TABLE JBPM4_HIST_ACTINST;
      DROP TABLE JBPM4_HIST_TASK;
      DROP TABLE JBPM4_SWIMLANE;
      DROP TABLE JBPM4_TASK;
      DROP TABLE JBPM4_PARTICIPATION;
      DROP TABLE JBPM4_PROPERTY;
      DROP TABLE JBPM4_LOB;
      DROP TABLE JBPM4_JOB;
      SET foreign_key_checks = 1;

 

 

 

 

 

< Back | How To Main Page| Next How To Article >

Was this article helpful to you?

Rob Marshall

Comments are closed.