C11/System/OPTIMA/SQL/exec/OPTIMA_import_Truncate.sql

USE [OPTIMA]
GO

TRUNCATE TABLE [import].[AA_TRTYPE]
GO

TRUNCATE TABLE [import].[ACCOUNT_INFO]
GO

TRUNCATE TABLE [import].[ACCT_BALANCE]
GO

TRUNCATE TABLE [import].[ACCT_DOC_DATA]
GO

TRUNCATE TABLE [import].[ACCT_DOC_DATA_01]
GO

TRUNCATE TABLE [import].[ACCT_DOC_KEY]
GO

TRUNCATE TABLE [import].[ACCT_DOC_KEY_01]
GO

TRUNCATE TABLE [import].[ACCT_DOC_SALESCLAS]
GO

TRUNCATE TABLE [import].[ACTIVITY]
GO

TRUNCATE TABLE [import].[APPORTIONED_INV_TIME]
GO

TRUNCATE TABLE [import].[APPORTIONED_USED_TIME]
GO

TRUNCATE TABLE [import].[CALENDAR_EVENT]
GO

TRUNCATE TABLE [import].[CALENDAR_INFO]
GO

TRUNCATE TABLE [import].[CALENDAR_PATTERN]
GO

TRUNCATE TABLE [import].[CAR_STATISTIC]
GO

TRUNCATE TABLE [import].[COMM_TRANS_UNIT]
GO

TRUNCATE TABLE [import].[COMM_UNIT]
GO

TRUNCATE TABLE [import].[COURTESY_CAR]
GO

TRUNCATE TABLE [import].[CUSTOMER]
GO

TRUNCATE TABLE [import].[CUSTOMER_Dennis]
GO

TRUNCATE TABLE [import].[CUSTOMER_TRANSACT]
GO

TRUNCATE TABLE [import].[DEPARTMENT_TYPE]
GO

TRUNCATE TABLE [import].[EMPLOYEE]
GO

TRUNCATE TABLE [import].[ORDER_ACCUMULATION]
GO

TRUNCATE TABLE [import].[ORDER_HEADER]
GO

TRUNCATE TABLE [import].[ORDER_LINE]
GO

TRUNCATE TABLE [import].[ORDER_OPEN_ITEMS]
GO

TRUNCATE TABLE [import].[ORDER_SERVICE_SCHEMES]
GO

TRUNCATE TABLE [import].[PERSON]
GO

TRUNCATE TABLE [import].[PERSON_INFO]
GO

TRUNCATE TABLE [import].[PRODUCT_FILE]
GO

TRUNCATE TABLE [import].[PRODUCT_STOCK_FILE]
GO

TRUNCATE TABLE [import].[PROFILE]
GO

TRUNCATE TABLE [import].[PROFILE_TYPE]
GO

TRUNCATE TABLE [import].[PUNCH]
GO

TRUNCATE TABLE [import].[PURCH_DISC_TYPES]
GO

TRUNCATE TABLE [import].[PURCH_DISCOUNTS]
GO

TRUNCATE TABLE [import].[SERVICE_2000_FILE]
GO

TRUNCATE TABLE [import].[SUPPLIER]
GO

TRUNCATE TABLE [import].[SUPPLIER_TRANSACT]
GO

TRUNCATE TABLE [import].[TIME_CONTROL_END]
GO

TRUNCATE TABLE [import].[TIME_CONTROL_OPEN]
GO

TRUNCATE TABLE [import].[TIME_CONTROL_TRANS]
GO

TRUNCATE TABLE [import].[TRANSACTION_TYPE]
GO

TRUNCATE TABLE [import].[UNIT_CHANGE_HIST]
GO

TRUNCATE TABLE [import].[UNIT_CLASSIFICAT]
GO

TRUNCATE TABLE [import].[UNIT_FILE]
GO

TRUNCATE TABLE [import].[UNIT_HISTORY]
GO

TRUNCATE TABLE [import].[UNIT_LINK_EXT]
GO

TRUNCATE TABLE [import].[UNIT_SALES_PRICE_LOG]
GO

TRUNCATE TABLE [import].[UNIT_STATUS_HIST]
GO

TRUNCATE TABLE [import].[UNIT_TEMP_TAB_GRNI]
GO

TRUNCATE TABLE [import].[UNIT_TRANSFER_TAB]
GO

TRUNCATE TABLE [import].[UNIT_TYPE_FILE]
GO

TRUNCATE TABLE [import].[UPDATE_OPTION]
GO

TRUNCATE TABLE [import].[VEH_CARGRP_PURCHORIGIN]
GO

TRUNCATE TABLE [import].[VEH_CLASSIFICATION_CODE]
GO

TRUNCATE TABLE [import].[VEH_IN_TRANSIT]
GO

TRUNCATE TABLE [import].[VEH_LINK_EXT]
GO

TRUNCATE TABLE [import].[VEH_MAX_STOCK]
GO

TRUNCATE TABLE [import].[VEH_ORDER_HEADER]
GO

TRUNCATE TABLE [import].[VEH_ORDER_LINE]
GO

TRUNCATE TABLE [import].[VEH_ORDER_OPTION]
GO

TRUNCATE TABLE [import].[VEH_TRANSACT_COLUMNS]
GO

TRUNCATE TABLE [import].[VEH_TRANSACT_GRID]
GO

TRUNCATE TABLE [import].[VEH_TRANSACT_GROUPS]
GO

TRUNCATE TABLE [import].[VEH_TRANSMISSION_CODES]
GO

TRUNCATE TABLE [import].[VEHICLE]
GO

TRUNCATE TABLE [import].[VEHICLE_ACCRUALS]
GO

TRUNCATE TABLE [import].[VEHICLE_DOCKETCARD]
GO

TRUNCATE TABLE [import].[VEHICLE_EXTENSION]
GO

TRUNCATE TABLE [import].[VPP25]
GO

TRUNCATE TABLE [import].[vPP2C]
GO

TRUNCATE TABLE [import].[VPP43]
GO

TRUNCATE TABLE [import].[VPP48]
GO

TRUNCATE TABLE [import].[vPP4K]
GO

TRUNCATE TABLE [import].[vPP51]
GO

TRUNCATE TABLE [import].[vPP53]
GO

TRUNCATE TABLE [import].[vPP5A]
GO

TRUNCATE TABLE [import].[vPP5M]
GO

TRUNCATE TABLE [import].[VPP5Q]
GO

TRUNCATE TABLE [import].[vPP5R]
GO

TRUNCATE TABLE [import].[vPP61]
GO

TRUNCATE TABLE [import].[vPP65]
GO

TRUNCATE TABLE [import].[vPP72]
GO

TRUNCATE TABLE [import].[VPP73]
GO

TRUNCATE TABLE [import].[vPP74]
GO

TRUNCATE TABLE [import].[VPP91]
GO

TRUNCATE TABLE [import].[vPP93]
GO

TRUNCATE TABLE [import].[vPPT1]
GO

TRUNCATE TABLE [import].[WORK_LINE_STATUS]
GO

TRUNCATE TABLE [import].[WORK_UNITS]
GO

TRUNCATE TABLE [import].[WORKING_PERIOD]
GO

TRUNCATE TABLE [import].[WORKSHOP_ORDER_SPLIT]
GO

TRUNCATE TABLE [import].[WORKSHOP_PLANNING]
GO

TRUNCATE TABLE [import].[WORKSHOP_TEAMS]
GO