Быстро удаляем все таблицы в базе данный
Для редакции Бизнес
31 мая 2023 0:00
DROP TABLE `b_admin_notify`, `b_admin_notify_lang`, `b_adv_banner`, `b_adv_banner_2_country`, `b_adv_banner_2_day`, `b_adv_banner_2_group`, `b_adv_banner_2_page`, `b_adv_banner_2_site`, `b_adv_banner_2_stat_adv`, `b_adv_banner_2_weekday`, `b_adv_contract`, `b_adv_contract_2_page`, `b_adv_contract_2_site`, `b_adv_contract_2_type`, `b_adv_contract_2_user`, `b_adv_contract_2_weekday`, `b_adv_type`, `b_agent`, `b_app_password`, `b_b24connector_buttons`, `b_b24connector_button_site`, `b_bitrixcloud_option`, `b_blog`, `b_blog_category`, `b_blog_comment`, `b_blog_group`, `b_blog_image`, `b_blog_post`, `b_blog_post_category`, `b_blog_post_param`, `b_blog_site_path`, `b_blog_socnet`, `b_blog_socnet_rights`, `b_blog_trackback`, `b_blog_user`, `b_blog_user2blog`, `b_blog_user2user_group`, `b_blog_user_group`, `b_blog_user_group_perms`, `b_bp_automation_trigger`, `b_bp_global_const`, `b_bp_global_var`, `b_bp_history`, `b_bp_rest_activity`, `b_bp_rest_provider`, `b_bp_scheduler_event`, `b_bp_script`, `b_bp_script_queue`, `b_bp_script_queue_document`, `b_bp_storage_activity`, `b_bp_task`, `b_bp_task_user`, `b_bp_tracking`, `b_bp_workflow_instance`, `b_bp_workflow_permissions`, `b_bp_workflow_state`, `b_bp_workflow_state_identify`, `b_bp_workflow_template`, `b_cache_tag`, `b_calendar_access`, `b_calendar_attendees`, `b_calendar_event`, `b_calendar_event_sect`, `b_calendar_location`, `b_calendar_log`, `b_calendar_push`, `b_calendar_resource`, `b_calendar_section`, `b_calendar_type`, `b_captcha`, `b_catalog_contractor`, `b_catalog_currency`, `b_catalog_currency_lang`, `b_catalog_currency_rate`, `b_catalog_discount`, `b_catalog_discount2cat`, `b_catalog_discount2group`, `b_catalog_discount2iblock`, `b_catalog_discount2product`, `b_catalog_discount2section`, `b_catalog_discount_cond`, `b_catalog_discount_coupon`, `b_catalog_discount_entity`, `b_catalog_discount_module`, `b_catalog_disc_save_group`, `b_catalog_disc_save_range`, `b_catalog_disc_save_user`, `b_catalog_docs_barcode`, `b_catalog_docs_element`, `b_catalog_export`, `b_catalog_extra`, `b_catalog_group`, `b_catalog_group2group`, `b_catalog_group_lang`, `b_catalog_iblock`, `b_catalog_load`, `b_catalog_measure`, `b_catalog_measure_ratio`, `b_catalog_price`, `b_catalog_product`, `b_catalog_product2group`, `b_catalog_product_sets`, `b_catalog_rounding`, `b_catalog_store`, `b_catalog_store_barcode`, `b_catalog_store_docs`, `b_catalog_store_document_file`, `b_catalog_store_product`, `b_catalog_subscribe`, `b_catalog_subscribe_access`, `b_catalog_vat`, `b_catalog_viewed_product`, `b_checklist`, `b_clouds_copy_queue`, `b_clouds_delete_queue`, `b_clouds_file_bucket`, `b_clouds_file_hash`, `b_clouds_file_resize`, `b_clouds_file_save`, `b_clouds_file_upload`, `b_component_params`, `b_composite_log`, `b_composite_page`, `b_consent_agreement`, `b_consent_field`, `b_consent_user_consent`, `b_consent_user_consent_item`, `b_conv_context`, `b_conv_context_attribute`, `b_conv_context_counter_day`, `b_conv_context_entity_item`, `b_counter_data`, `b_culture`, `b_entity_usage`, `b_event`, `b_event_attachment`, `b_event_log`, `b_event_message`, `b_event_message_attachment`, `b_event_message_site`, `b_event_type`, `b_favorite`, `b_file`, `b_file_duplicate`, `b_file_hash`, `b_file_preview`, `b_file_search`, `b_filters`, `b_finder_dest`, `b_form`, `b_form_2_group`, `b_form_2_mail_template`, `b_form_2_site`, `b_form_answer`, `b_form_crm`, `b_form_crm_field`, `b_form_crm_link`, `b_form_field`, `b_form_field_filter`, `b_form_field_validator`, `b_form_menu`, `b_form_result`, `b_form_result_answer`, `b_form_status`, `b_form_status_2_group`, `b_form_status_2_mail_template`, `b_forum`, `b_forum2site`, `b_forum_dictionary`, `b_forum_email`, `b_forum_file`, `b_forum_filter`, `b_forum_group`, `b_forum_group_lang`, `b_forum_letter`, `b_forum_message`, `b_forum_perms`, `b_forum_pm_folder`, `b_forum_points`, `b_forum_points2post`, `b_forum_points_lang`, `b_forum_private_message`, `b_forum_rank`, `b_forum_rank_lang`, `b_forum_service_deleted_message`, `b_forum_service_statistic_queue`, `b_forum_stat`, `b_forum_subscribe`, `b_forum_topic`, `b_forum_user`, `b_forum_user_forum`, `b_forum_user_points`, `b_forum_user_topic`, `b_geoip_handlers`, `b_group`, `b_group_collection_task`, `b_group_subordinate`, `b_group_task`, `b_hlblock_entity`, `b_hlblock_entity_lang`, `b_hlblock_entity_rights`, `b_hlsys_marking_code_group`, `b_hot_keys`, `b_hot_keys_code`, `b_iblock`, `b_iblock_cache`, `b_iblock_element`, `b_iblock_element_iprop`, `b_iblock_element_lock`, `b_iblock_element_property`, `b_iblock_element_right`, `b_iblock_fields`, `b_iblock_group`, `b_iblock_iblock_iprop`, `b_iblock_iproperty`, `b_iblock_messages`, `b_iblock_offers_tmp`, `b_iblock_property`, `b_iblock_property_enum`, `b_iblock_property_feature`, `b_iblock_right`, `b_iblock_rss`, `b_iblock_section`, `b_iblock_section_element`, `b_iblock_section_iprop`, `b_iblock_section_property`, `b_iblock_section_right`, `b_iblock_sequence`, `b_iblock_site`, `b_iblock_type`, `b_iblock_type_lang`, `b_idea_email_subscribe`, `b_im_alias`, `b_im_app`, `b_im_app_lang`, `b_im_block_user`, `b_im_bot`, `b_im_bot_chat`, `b_im_bot_token`, `b_im_call`, `b_im_call_user`, `b_im_chat`, `b_im_chat_index`, `b_im_command`, `b_im_command_lang`, `b_im_conference`, `b_im_conference_user_role`, `b_im_external_avatar`, `b_im_last_search`, `b_im_message`, `b_im_message_favorite`, `b_im_message_index`, `b_im_message_param`, `b_im_message_uuid`, `b_im_no_relation_permission_disk`, `b_im_option_access`, `b_im_option_group`, `b_im_option_state`, `b_im_option_user`, `b_im_permission`, `b_im_permission_duration`, `b_im_permission_log`, `b_im_recent`, `b_im_relation`, `b_im_status`, `b_landing`, `b_landing_binding`, `b_landing_block`, `b_landing_block_last_used`, `b_landing_chat`, `b_landing_chat_binding`, `b_landing_cookies_agreement`, `b_landing_demo`, `b_landing_designer_repo`, `b_landing_domain`, `b_landing_entity_lock`, `b_landing_entity_rights`, `b_landing_file`, `b_landing_filter_block`, `b_landing_filter_entity`, `b_landing_folder`, `b_landing_hook_data`, `b_landing_placement`, `b_landing_repo`, `b_landing_role`, `b_landing_site`, `b_landing_syspage`, `b_landing_template`, `b_landing_template_ref`, `b_landing_update_block`, `b_landing_urlchecker_host`, `b_landing_urlchecker_status`, `b_landing_urlchecker_whitelist`, `b_landing_urlrewrite`, `b_landing_view`, `b_lang`, `b_language`, `b_lang_domain`, `b_learn_answer`, `b_learn_attempt`, `b_learn_certification`, `b_learn_chapter`, `b_learn_course`, `b_learn_course_site`, `b_learn_exceptions_log`, `b_learn_gradebook`, `b_learn_groups`, `b_learn_groups_lesson`, `b_learn_groups_member`, `b_learn_lesson`, `b_learn_lesson_edges`, `b_learn_publish_prohibition`, `b_learn_question`, `b_learn_rights`, `b_learn_rights_all`, `b_learn_site_path`, `b_learn_student`, `b_learn_test`, `b_learn_test_mark`, `b_learn_test_result`, `b_lists_field`, `b_lists_permission`, `b_lists_socnet_group`, `b_lists_url`, `b_list_rubric`, `b_log_notification`, `b_log_notification_action`, `b_mail_blacklist`, `b_mail_contact`, `b_mail_counter`, `b_mail_domain_email`, `b_mail_entity_options`, `b_mail_filter`, `b_mail_filter_cond`, `b_mail_log`, `b_mail_mailbox`, `b_mail_mailbox_access`, `b_mail_mailbox_dir`, `b_mail_mailservices`, `b_mail_message`, `b_mail_message_access`, `b_mail_message_closure`, `b_mail_message_delete_queue`, `b_mail_message_uid`, `b_mail_message_upload_queue`, `b_mail_msg_attachment`, `b_mail_oauth`, `b_mail_spam_weight`, `b_mail_user_message`, `b_mail_user_relations`, `b_mail_user_signature`, `b_main_mail_blacklist`, `b_main_mail_sender`, `b_main_mail_sender_send_counter`, `b_medialib_collection`, `b_medialib_collection_item`, `b_medialib_item`, `b_medialib_type`, `b_messageservice_message`, `b_messageservice_rest_app`, `b_messageservice_rest_app_lang`, `b_mobileapp_app`, `b_mobileapp_config`, `b_module`, `b_module_group`, `b_module_to_module`, `b_numerator`, `b_numerator_sequence`, `b_operation`, `b_option`, `b_option_site`, `b_perf_cache`, `b_perf_cluster`, `b_perf_component`, `b_perf_error`, `b_perf_history`, `b_perf_hit`, `b_perf_index_ban`, `b_perf_index_complete`, `b_perf_index_suggest`, `b_perf_index_suggest_sql`, `b_perf_sql`, `b_perf_sql_backtrace`, `b_perf_tab_column_stat`, `b_perf_tab_stat`, `b_perf_test`, `b_posting`, `b_posting_email`, `b_posting_file`, `b_posting_group`, `b_posting_rubric`, `b_pull_channel`, `b_pull_push`, `b_pull_push_queue`, `b_pull_stack`, `b_pull_watch`, `b_rating`, `b_rating_component`, `b_rating_component_results`, `b_rating_prepare`, `b_rating_results`, `b_rating_rule`, `b_rating_rule_vetting`, `b_rating_user`, `b_rating_vote`, `b_rating_vote_group`, `b_rating_voting`, `b_rating_voting_prepare`, `b_rating_voting_reaction`, `b_rating_weight`, `b_report`, `b_report_sharing`, `b_report_visual_report_configuration`, `b_report_visual_report_dashboard`, `b_report_visual_report_dashboard_row`, `b_report_visual_report_entity`, `b_report_visual_report_entity_config`, `b_report_visual_report_widget`, `b_report_visual_report_widget_config`, `b_rest_ap`, `b_rest_app`, `b_rest_app_lang`, `b_rest_app_log`, `b_rest_ap_permission`, `b_rest_configuration_storage`, `b_rest_event`, `b_rest_event_offline`, `b_rest_integration`, `b_rest_log`, `b_rest_owner_entity`, `b_rest_placement`, `b_rest_placement_lang`, `b_rest_stat`, `b_rest_stat_app`, `b_rest_stat_method`, `b_rest_usage_entity`, `b_rest_usage_stat`, `b_sale_affiliate`, `b_sale_affiliate_plan`, `b_sale_affiliate_plan_section`, `b_sale_affiliate_tier`, `b_sale_affiliate_transact`, `b_sale_analytics`, `b_sale_auxiliary`, `b_sale_b24integration_bind`, `b_sale_b24integration_relation`, `b_sale_b24integration_stat`, `b_sale_b24integration_stat_provider`, `b_sale_b24integration_token`, `b_sale_basket`, `b_sale_basket_archive`, `b_sale_basket_archive_packed`, `b_sale_basket_props`, `b_sale_basket_reservation`, `b_sale_basket_reservation_history`, `b_sale_bizval`, `b_sale_bizval_code_1c`, `b_sale_bizval_persondomain`, `b_sale_buyer_stat`, `b_sale_cashbox`, `b_sale_cashbox_check`, `b_sale_cashbox_check_correction`, `b_sale_cashbox_connect`, `b_sale_cashbox_err_log`, `b_sale_cashbox_rest_handler`, `b_sale_cashbox_z_report`, `b_sale_check2cashbox`, `b_sale_check_related_entities`, `b_sale_company`, `b_sale_company2location`, `b_sale_company2service`, `b_sale_company_group`, `b_sale_company_resp_grp`, `b_sale_delivery2location`, `b_sale_delivery2paysystem`, `b_sale_delivery_es`, `b_sale_delivery_req`, `b_sale_delivery_req_shp`, `b_sale_delivery_rest_handler`, `b_sale_delivery_srv`, `b_sale_delivery_yandex_taxi_claims`, `b_sale_discount`, `b_sale_discount_coupon`, `b_sale_discount_entities`, `b_sale_discount_group`, `b_sale_discount_module`, `b_sale_documentgenerator_callback_registry`, `b_sale_domain_verification`, `b_sale_d_ix_element`, `b_sale_d_ix_section`, `b_sale_entity_marker`, `b_sale_exchange_log`, `b_sale_export`, `b_sale_facebook_conversion_params`, `b_sale_fuser`, `b_sale_gift_related_data`, `b_sale_hdaln`, `b_sale_lang`, `b_sale_location`, `b_sale_location2location_group`, `b_sale_location_city`, `b_sale_location_city_lang`, `b_sale_location_country`, `b_sale_location_country_lang`, `b_sale_location_group`, `b_sale_location_group_lang`, `b_sale_location_region`, `b_sale_location_region_lang`, `b_sale_location_zip`, `b_sale_loc_2site`, `b_sale_loc_def2site`, `b_sale_loc_ext`, `b_sale_loc_ext_srv`, `b_sale_loc_name`, `b_sale_loc_type`, `b_sale_loc_type_name`, `b_sale_order`, `b_sale_order_archive`, `b_sale_order_archive_packed`, `b_sale_order_change`, `b_sale_order_converter_crm_error`, `b_sale_order_coupons`, `b_sale_order_delivery`, `b_sale_order_delivery_es`, `b_sale_order_delivery_req`, `b_sale_order_discount`, `b_sale_order_discount_data`, `b_sale_order_dlv_basket`, `b_sale_order_entities_custom_fields`, `b_sale_order_flags2group`, `b_sale_order_history`, `b_sale_order_modules`, `b_sale_order_payment`, `b_sale_order_payment_item`, `b_sale_order_payment_ps_available`, `b_sale_order_processing`, `b_sale_order_product_stat`, `b_sale_order_props`, `b_sale_order_props_group`, `b_sale_order_props_relation`, `b_sale_order_props_value`, `b_sale_order_props_variant`, `b_sale_order_round`, `b_sale_order_rules`, `b_sale_order_rules_descr`, `b_sale_order_tax`, `b_sale_pay_system_action`, `b_sale_pay_system_err_log`, `b_sale_pay_system_rest_handlers`, `b_sale_person_type`, `b_sale_person_type_site`, `b_sale_product2product`, `b_sale_recurring`, `b_sale_service_rstr`, `b_sale_site2group`, `b_sale_status`, `b_sale_status_group_task`, `b_sale_status_lang`, `b_sale_store_barcode`, `b_sale_synchronizer_log`, `b_sale_tax`, `b_sale_tax2location`, `b_sale_tax_exempt2group`, `b_sale_tax_rate`, `b_sale_tp`, `b_sale_tp_ebay_cat`, `b_sale_tp_ebay_cat_var`, `b_sale_tp_ebay_fq`, `b_sale_tp_ebay_fr`, `b_sale_tp_map`, `b_sale_tp_map_entity`, `b_sale_tp_order`, `b_sale_tp_vk_log`, `b_sale_tp_vk_profile`, `b_sale_usergroup_restr`, `b_sale_user_account`, `b_sale_user_cards`, `b_sale_user_props`, `b_sale_user_props_value`, `b_sale_user_transact`, `b_sale_viewed_product`, `b_sale_yandex_settings`, `b_search_content`, `b_search_content_freq`, `b_search_content_param`, `b_search_content_right`, `b_search_content_site`, `b_search_content_stem`, `b_search_content_text`, `b_search_content_title`, `b_search_custom_rank`, `b_search_phrase`, `b_search_stem`, `b_search_suggest`, `b_search_tags`, `b_search_user_right`, `b_security_sitecheck`, `b_sec_filter_mask`, `b_sec_frame_mask`, `b_sec_iprule`, `b_sec_iprule_excl_ip`, `b_sec_iprule_excl_mask`, `b_sec_iprule_incl_ip`, `b_sec_iprule_incl_mask`, `b_sec_recovery_codes`, `b_sec_redirect_url`, `b_sec_session`, `b_sec_user`, `b_sec_virus`, `b_sec_white_list`, `b_sender_abuse`, `b_sender_agreement`, `b_sender_call_log`, `b_sender_contact`, `b_sender_contact_list`, `b_sender_counter`, `b_sender_counter_daily`, `b_sender_file`, `b_sender_group`, `b_sender_group_connector`, `b_sender_group_counter`, `b_sender_group_data`, `b_sender_group_deal_category`, `b_sender_group_queue`, `b_sender_group_state`, `b_sender_group_thread`, `b_sender_list`, `b_sender_mailing`, `b_sender_mailing_attachment`, `b_sender_mailing_chain`, `b_sender_mailing_chain_group`, `b_sender_mailing_group`, `b_sender_mailing_subscription`, `b_sender_mailing_trigger`, `b_sender_message`, `b_sender_message_field`, `b_sender_message_utm`, `b_sender_permission`, `b_sender_posting`, `b_sender_posting_click`, `b_sender_posting_read`, `b_sender_posting_recipient`, `b_sender_posting_thread`, `b_sender_posting_unsub`, `b_sender_preset_template`, `b_sender_queue`, `b_sender_role`, `b_sender_role_access`, `b_sender_role_permission`, `b_sender_role_relation`, `b_sender_timeline_queue`, `b_seo_adv_autolog`, `b_seo_adv_banner`, `b_seo_adv_campaign`, `b_seo_adv_group`, `b_seo_adv_link`, `b_seo_adv_log`, `b_seo_adv_order`, `b_seo_adv_region`, `b_seo_keywords`, `b_seo_search_engine`, `b_seo_service_log`, `b_seo_service_queue`, `b_seo_service_rtg_queue`, `b_seo_service_subscription`, `b_seo_service_webhook`, `b_seo_sitemap`, `b_seo_sitemap_entity`, `b_seo_sitemap_iblock`, `b_seo_sitemap_runtime`, `b_seo_yandex_direct_stat`, `b_short_uri`, `b_site_template`, `b_smile`, `b_smile_lang`, `b_smile_set`, `b_sms_template`, `b_sms_template_site`, `b_sm_version_history`, `b_socialservices_ap`, `b_socialservices_contact`, `b_socialservices_contact_connect`, `b_socialservices_message`, `b_socialservices_user`, `b_socialservices_user_link`, `b_socialservices_zoom_meeting`, `b_socialservices_zoom_meeting_recording`, `b_sonet_event_user_view`, `b_sonet_features`, `b_sonet_features2perms`, `b_sonet_group`, `b_sonet_group_favorites`, `b_sonet_group_site`, `b_sonet_group_subject`, `b_sonet_group_subject_site`, `b_sonet_group_tag`, `b_sonet_group_view`, `b_sonet_log`, `b_sonet_log_comment`, `b_sonet_log_counter`, `b_sonet_log_events`, `b_sonet_log_favorites`, `b_sonet_log_follow`, `b_sonet_log_index`, `b_sonet_log_page`, `b_sonet_log_pinned`, `b_sonet_log_right`, `b_sonet_log_site`, `b_sonet_log_smartfilter`, `b_sonet_log_subscribe`, `b_sonet_log_tag`, `b_sonet_log_view`, `b_sonet_messages`, `b_sonet_smile`, `b_sonet_smile_lang`, `b_sonet_subscription`, `b_sonet_user2group`, `b_sonet_user_content_view`, `b_sonet_user_events`, `b_sonet_user_perms`, `b_sonet_user_relations`, `b_sonet_user_tag`, `b_sonet_user_welltory`, `b_sonet_user_welltory_disclaimer`, `b_stat_adv`, `b_stat_adv_day`, `b_stat_adv_event`, `b_stat_adv_event_day`, `b_stat_adv_guest`, `b_stat_adv_page`, `b_stat_adv_searcher`, `b_stat_browser`, `b_stat_city`, `b_stat_city_day`, `b_stat_city_ip`, `b_stat_country`, `b_stat_country_day`, `b_stat_day`, `b_stat_day_site`, `b_stat_ddl`, `b_stat_event`, `b_stat_event_day`, `b_stat_event_list`, `b_stat_guest`, `b_stat_hit`, `b_stat_page`, `b_stat_page_adv`, `b_stat_path`, `b_stat_path_adv`, `b_stat_path_cache`, `b_stat_phrase_list`, `b_stat_referer`, `b_stat_referer_list`, `b_stat_searcher`, `b_stat_searcher_day`, `b_stat_searcher_hit`, `b_stat_searcher_params`, `b_stat_session`, `b_stat_session_data`, `b_sticker`, `b_sticker_group_task`, `b_stop_list`, `b_subscription`, `b_subscription_rubric`, `b_task`, `b_task_operation`, `b_ticket`, `b_ticket_dictionary`, `b_ticket_dictionary_2_site`, `b_ticket_holidays`, `b_ticket_message`, `b_ticket_message_2_file`, `b_ticket_online`, `b_ticket_search`, `b_ticket_sla`, `b_ticket_sla_2_category`, `b_ticket_sla_2_criticality`, `b_ticket_sla_2_holidays`, `b_ticket_sla_2_mark`, `b_ticket_sla_2_site`, `b_ticket_sla_2_user_group`, `b_ticket_sla_shedule`, `b_ticket_supercoupons`, `b_ticket_supercoupons_log`, `b_ticket_timetable`, `b_ticket_timetable_cache`, `b_ticket_ugroups`, `b_ticket_user_ugroup`, `b_translate_diff`, `b_translate_file`, `b_translate_path`, `b_translate_path_lang`, `b_translate_path_tree`, `b_translate_phrase`, `b_ui_entity_editor_config`, `b_ui_entity_editor_config_ac`, `b_undo`, `b_urlpreview_metadata`, `b_urlpreview_route`, `b_user`, `b_user_access`, `b_user_access_check`, `b_user_auth_action`, `b_user_auth_code`, `b_user_counter`, `b_user_digest`, `b_user_field`, `b_user_field_confirm`, `b_user_field_enum`, `b_user_field_lang`, `b_user_field_permission`, `b_user_group`, `b_user_hit_auth`, `b_user_index`, `b_user_option`, `b_user_password`, `b_user_phone_auth`, `b_user_profile_history`, `b_user_profile_record`, `b_user_session`, `b_user_stored_auth`, `b_utm_blog_comment`, `b_utm_blog_post`, `b_utm_forum_message`, `b_utm_product`, `b_utm_sonet_comment`, `b_utm_sonet_log`, `b_utm_user`, `b_uts_blog_comment`, `b_uts_blog_post`, `b_uts_forum_message`, `b_uts_product`, `b_uts_sonet_comment`, `b_uts_sonet_log`, `b_uts_user`, `b_vote`, `b_vote_answer`, `b_vote_attached_object`, `b_vote_channel`, `b_vote_channel_2_group`, `b_vote_channel_2_site`, `b_vote_event`, `b_vote_event_answer`, `b_vote_event_question`, `b_vote_question`, `b_vote_user`, `b_workflow_document`, `b_workflow_file`, `b_workflow_log`, `b_workflow_move`, `b_workflow_preview`, `b_workflow_status`, `b_workflow_status2group`, `b_xml_tree`;