LOCOSOFT_import_Truncate.sql 2.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153
  1. USE [LOCOSOFT]
  2. GO
  3. TRUNCATE TABLE [dbo].[absence_calendar]
  4. GO
  5. TRUNCATE TABLE [dbo].[absence_reasons]
  6. GO
  7. TRUNCATE TABLE [dbo].[absence_types]
  8. GO
  9. TRUNCATE TABLE [dbo].[accounts_characteristics]
  10. GO
  11. TRUNCATE TABLE [dbo].[charge_type_descriptions]
  12. GO
  13. TRUNCATE TABLE [dbo].[charge_types]
  14. GO
  15. TRUNCATE TABLE [dbo].[clearing_delay_types]
  16. GO
  17. TRUNCATE TABLE [dbo].[com_number_types]
  18. GO
  19. TRUNCATE TABLE [dbo].[customer_codes]
  20. GO
  21. TRUNCATE TABLE [dbo].[customer_com_numbers]
  22. GO
  23. TRUNCATE TABLE [dbo].[customer_to_customercodes]
  24. GO
  25. TRUNCATE TABLE [dbo].[customers_suppliers]
  26. GO
  27. TRUNCATE TABLE [dbo].[document_types]
  28. GO
  29. TRUNCATE TABLE [dbo].[employees]
  30. GO
  31. TRUNCATE TABLE [dbo].[employees_breaktimes]
  32. GO
  33. TRUNCATE TABLE [dbo].[employees_history]
  34. GO
  35. TRUNCATE TABLE [dbo].[employees_worktimes]
  36. GO
  37. TRUNCATE TABLE [dbo].[fuels]
  38. GO
  39. TRUNCATE TABLE [dbo].[invoice_types]
  40. GO
  41. TRUNCATE TABLE [dbo].[invoices]
  42. GO
  43. TRUNCATE TABLE [dbo].[journal_accountings]
  44. GO
  45. TRUNCATE TABLE [dbo].[labour_types]
  46. GO
  47. TRUNCATE TABLE [dbo].[labours]
  48. GO
  49. TRUNCATE TABLE [dbo].[makes]
  50. GO
  51. TRUNCATE TABLE [dbo].[model_to_fuels]
  52. GO
  53. TRUNCATE TABLE [dbo].[models]
  54. GO
  55. TRUNCATE TABLE [dbo].[nominal_accounts]
  56. GO
  57. TRUNCATE TABLE [dbo].[order_positions]
  58. GO
  59. TRUNCATE TABLE [dbo].[part_types]
  60. GO
  61. TRUNCATE TABLE [dbo].[parts]
  62. GO
  63. TRUNCATE TABLE [dbo].[parts_rebate_groups_buy]
  64. GO
  65. TRUNCATE TABLE [dbo].[parts_rebate_groups_sell]
  66. GO
  67. TRUNCATE TABLE [dbo].[time_types]
  68. GO
  69. TRUNCATE TABLE [dbo].[times]
  70. GO
  71. TRUNCATE TABLE [dbo].[vat_keys]
  72. GO
  73. TRUNCATE TABLE [dbo].[vehicle_bodys]
  74. GO
  75. TRUNCATE TABLE [dbo].[vehicles]
  76. GO
  77. TRUNCATE TABLE [dbo].[year_calendar]
  78. GO
  79. TRUNCATE TABLE [dbo].[year_calendar_day_off_codes]
  80. GO
  81. TRUNCATE TABLE [dbo].[year_calendar_subsidiary_mapping]
  82. GO
  83. TRUNCATE TABLE [dbo].[codes_vehicle_date]
  84. GO
  85. TRUNCATE TABLE [dbo].[codes_vehicle_date_def]
  86. GO
  87. TRUNCATE TABLE [dbo].[codes_vehicle_def]
  88. GO
  89. TRUNCATE TABLE [dbo].[codes_vehicle_list]
  90. GO
  91. TRUNCATE TABLE [dbo].[codes_vehicle_mileage]
  92. GO
  93. TRUNCATE TABLE [dbo].[codes_vehicle_mileage_def]
  94. GO
  95. TRUNCATE TABLE [dbo].[dealer_vehicles]
  96. GO
  97. TRUNCATE TABLE [dbo].[vehicle_buy_types]
  98. GO
  99. TRUNCATE TABLE [dbo].[vehicle_pre_owned_codes]
  100. GO
  101. TRUNCATE TABLE [dbo].[vehicle_sale_types]
  102. GO