LOCOSOFT_dbo_Drop.sql 2.0 KB

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