mh_sms/SQL/删除/删除.txt

28 lines
1014 B
Plaintext
Raw Permalink Normal View History

2024-04-12 16:50:28 +08:00
DELETE T_PF_APPROVE_DETAIL
delete T_BS_SAFE_CHECK_PROJECT_CATEGORY
delete T_BS_SAFE_CHECK_RISK_AREA
delete T_BS_SAFE_CHECK_PROJECT
delete T_BS_SAFE_CHECK_USERSIGN
delete T_BS_RISK_SUBMIT_CONTENT_DEAL
delete T_BS_RISK_SUBMIT_CONTENT_DEAL_AFTER_FILE
delete T_BS_RISK_SUBMIT_CONTENT_DEAL_FILE
delete T_BS_SAFE_CHECK_DETAIL_QUESTION
delete T_BS_SAFE_CHECK_DETAIL_USER
delete T_BS_SAFE_CHECK_DETAIL
delete T_BS_SAFE_CHECK
delete T_BS_RISK_SUBMIT_CONTENT
delete T_BS_SAFE_CHECK_FILE
delete T_BS_RISK_SUBMIT_NOTICE_PERSON
delete T_BS_RISK_SUBMIT_NOTICE
delete T_BS_RISK_SUBMIT
--待办
delete T_FM_NOTIFICATION_TASK where source_formcode like 'BS%'
delete T_FM_NOTIFICATION_TASK where source_formcode = 'PF119' and notice_title like '%检查%'
--检查库删除 看实际删除情况
delete [dbo].T_BS_CHECK_CONTENT_MAIN_DEPARTMENT
delete [dbo].[T_BS_CHECK_MAIN]
delete T_BS_CHECK_PROJECT
delete T_BS_CHECK_QUESTION where id not in ('77777777-7777-7777-7777-777777777777','55555555-5555-5555-5555-555555555555')