Нет описания

sql_20190513_清理.sql 1.4KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344
  1. truncate table rep_agent_detail
  2. truncate table dbo.rep_agent_state
  3. truncate table dbo.rep_conference
  4. truncate table dbo.rep_ext_call_in
  5. truncate table dbo.rep_ext_call_out
  6. truncate table dbo.rep_transfer
  7. truncate table dbo.rep_trunk_call_in
  8. truncate table dbo.T_Call_Blacklist
  9. truncate table dbo.T_Call_CallRecords
  10. truncate table dbo.T_Call_CallRecordsLD
  11. truncate table dbo.T_Call_LeaveRecord
  12. truncate table dbo.T_Call_ZBDH
  13. truncate table dbo.T_Cus_ContactPersonNew
  14. truncate table dbo.T_Cus_CustomerBaseNew
  15. truncate table dbo.T_Cus_CustomerFinance
  16. truncate table dbo.T_Cus_CustomerFinanceLog
  17. truncate table dbo.T_Cus_Region_UserAccount_Map
  18. truncate table dbo.T_Cus_RegionCategory
  19. truncate table dbo.T_Msg_List
  20. truncate table dbo.T_Msg_NoticeInfo
  21. truncate table dbo.T_SMS_List
  22. truncate table dbo.T_SMS_Receive
  23. truncate table dbo.T_SMS_RecvSMS
  24. truncate table dbo.T_SMS_SendSMSTask
  25. truncate table dbo.T_SMS_SentSMS
  26. truncate table dbo.T_Sys_Accessories
  27. truncate table dbo.T_Sys_CallOptLogs
  28. truncate table dbo.T_Sys_LoginLogs
  29. truncate table dbo.T_Wo_BusinessManage
  30. truncate table dbo.T_Wo_WorkOrder
  31. truncate table dbo.T_Wo_WorkOrder_Logs
  32. truncate table dbo.T_Wo_WorkOrderItem_New
  33. --delete from T_RepositoryCategory where F_CategoryId>2
  34. drop table dbo.T_Cus_ContactPerson
  35. drop table dbo.T_Cus_CustomerBase
  36. drop table dbo.T_Vis_DXNTelphone
  37. drop table dbo.T_Vis_DXOTelphone
  38. drop table dbo.T_Vis_DXTelRecords