ARI_Truncate.sql 1.5 KB

12345678910111213141516171819202122232425262728293031323334353637
  1. TRUNCATE TABLE [import].[Service Ledger Entry]
  2. TRUNCATE TABLE [import].[Labor Ledger Entry]
  3. TRUNCATE TABLE [import].[Sales Credit Memo Line]
  4. TRUNCATE TABLE [import].[Add_ Service Ledger Entry]
  5. TRUNCATE TABLE [import].[Sales Invoice Header]
  6. TRUNCATE TABLE [import].[Service Line]
  7. TRUNCATE TABLE [import].[Cust_ Ledger Entry]
  8. TRUNCATE TABLE [import].[Time Entry_T]
  9. TRUNCATE TABLE [import].[Archived Service Header]
  10. TRUNCATE TABLE [import].[Time Clock Entry]
  11. TRUNCATE TABLE [import].[Value Entry]
  12. TRUNCATE TABLE [import].[Customer]
  13. TRUNCATE TABLE [import].[Sales Credit Memo Header]
  14. TRUNCATE TABLE [import].[Vehicle Ledger Entry]
  15. TRUNCATE TABLE [import].[Vehicle]
  16. TRUNCATE TABLE [import].[Archived Service Line]
  17. TRUNCATE TABLE [import].[Service Header]
  18. TRUNCATE TABLE [import].[Reminder_Fin_ Charge Entry]
  19. TRUNCATE TABLE [import].[Employee_T]
  20. TRUNCATE TABLE [import].[G_L Account]
  21. TRUNCATE TABLE [import].[Resource]
  22. TRUNCATE TABLE [import].[Employee]
  23. TRUNCATE TABLE [import].[Sales Invoice Line]
  24. TRUNCATE TABLE [import].[Time Account_T]
  25. TRUNCATE TABLE [import].[Salesperson_Purchaser]
  26. TRUNCATE TABLE [import].[Task Type]
  27. TRUNCATE TABLE [import].[Customer Group]
  28. TRUNCATE TABLE [import].[Department]
  29. TRUNCATE TABLE [import].[Item]
  30. TRUNCATE TABLE [import].[BMW SRD Movement Type]
  31. TRUNCATE TABLE [import].[BMW SRD Transaction]
  32. TRUNCATE TABLE [import].[G_L Budget Entry]
  33. TRUNCATE TABLE [import].[Detailed Cust_ Ledg_ Entry]
  34. TRUNCATE TABLE [import].[Vehicle Option]
  35. TRUNCATE TABLE [import].[G_L Entry]
  36. TRUNCATE TABLE [import].[Veh_ Price Sticker Header]
  37. TRUNCATE TABLE [import].[Sales Line]