/* Cross match the results of used tables from OCTP-724 with the excel file from Delphix to reognize which tables are used or not !!! the used / not used flag is consistant only on "used" tables. The list have been compiled from an audit in production pharmacies over 1 month. Every tables used in that period has been marked as so, but we could have tables rarely used that are marked as unused but are still in use 1 or 2 times a year. 26.04.2024, TSC */ DECLARE @usedTables TABLE( fqdn VARCHAR(255) NOT NULL , schem AS LEFT([fqdn], CHARINDEX('.', [fqdn])-1) , tbl AS SUBSTRING([fqdn], CHARINDEX('.', [fqdn])+1, 999) ); DECLARE @toAnswer TABLE( fqdn VARCHAR(255) NOT NULL , schem AS LEFT([fqdn], CHARINDEX('.', [fqdn])-1) , tbl AS SUBSTRING([fqdn], CHARINDEX('.', [fqdn])+1, 999) ); --fetched from OCTP-724 INSERT INTO @usedTables ([fqdn]) SELECT DISTINCT tblNameUsed FROM ( VALUES ('AP.CustomerReminder') ,('AP.PrescriptionBookDetail') ,('AP.PrescriptionBookHeader') ,('AP.RepetitionReminder') ,('AP.SaleLoyalty') ,('AP.SaleWallet') ,('AP.ScannedDocument') ,('AP.StarcardValidity') ,('AP.WebShopStatusQueue') ,('atl.SQL_error_log') ,('crs.ProcessMessageLog') ,('dbo.Account') ,('dbo.Account_chart') ,('dbo.Account_group') ,('dbo.Account_key') ,('dbo.Account_link') ,('dbo.Account_text') ,('dbo.Accounting_period') ,('dbo.Accounting_plan') ,('dbo.ACG_pre_cost_entry_link') ,('dbo.Address') ,('dbo.Address_category') ,('dbo.Address_contact_person_list') ,('dbo.Address_criteria') ,('dbo.Address_group') ,('dbo.Address_invitation') ,('dbo.Address_key') ,('dbo.Address_link') ,('dbo.Address_monitor') ,('dbo.Address_type') ,('dbo.AGD_DL_link') ,('dbo.Alloy_transaction') ,('dbo.APS_connection_info') ,('dbo.APS_monitor_row') ,('dbo.APS_monitor_table') ,('dbo.APS_version_history') ,('dbo.ASDP_detail') ,('dbo.Asset') ,('dbo.Automatic_data_acquisition') ,('dbo.Batch_run') ,('dbo.Batch_type') ,('dbo.Batch_type_text') ,('dbo.Bmc_application_default') ,('dbo.Bmc_application_key') ,('dbo.Bmc_batch_type') ,('dbo.Bmc_desktop_property') ,('dbo.Bmc_form_preference') ,('dbo.Bmc_form_property') ,('dbo.Bmc_ID_counter') ,('dbo.Bmc_role') ,('dbo.Bmc_role_text') ,('dbo.Bmc_row_level_security') ,('dbo.Bmc_task') ,('dbo.Bmc_user_profile') ,('dbo.Bmc_user_role') ,('dbo.BOM_line') ,('dbo.BOM_option_header') ,('dbo.Brand') ,('dbo.Brand_text') ,('dbo.BVR_line') ,('dbo.BVR_member') ,('dbo.CCI_ATA_guarantee') ,('dbo.CCI_document_header') ,('dbo.Communication_history') ,('dbo.Company') ,('dbo.Cost_accounting_type') ,('dbo.Cost_entry') ,('dbo.Country') ,('dbo.Country_text') ,('dbo.CR_receipt_detail') ,('dbo.CR_receipt_master') ,('dbo.Criteria') ,('dbo.Criteria_text') ,('dbo.Criteria_type') ,('dbo.CRS_batch_run') ,('dbo.CRS_document_header') ,('dbo.Currency') ,('dbo.Currency_rate') ,('dbo.Currency_text') ,('dbo.Customer') ,('dbo.Customer_card') ,('dbo.Data_interface_status') ,('dbo.DBA_Working_hours') ,('dbo.Default_journal') ,('dbo.Delivery_code') ,('dbo.DH_address_link') ,('dbo.DH_criteria') ,('dbo.DH_customer_card_link') ,('dbo.DH_facility_link') ,('dbo.DH_loyalty_card') ,('dbo.DH_pre_calc_header') ,('dbo.DH_pre_calc_surplus') ,('dbo.DH_status_history') ,('dbo.DiscountVoucher') ,('dbo.DL_alloy_batch') ,('dbo.DL_BML_link') ,('dbo.DL_criteria') ,('dbo.DL_planning') ,('dbo.DL_posology') ,('dbo.DL_pre_calc_material') ,('dbo.DL_pre_calc_process_line') ,('dbo.DL_quantity_formula') ,('dbo.DL_unit_price_breakdown') ,('dbo.DL_WKOP_link') ,('dbo.Doc_header_customs_info') ,('dbo.Document_counter') ,('dbo.Document_date') ,('dbo.Document_error') ,('dbo.Document_error_link') ,('dbo.Document_header') ,('dbo.Document_header_link') ,('dbo.Document_header_revision') ,('dbo.Document_header_text') ,('dbo.Document_line') ,('dbo.Document_line_date') ,('dbo.Document_line_link') ,('dbo.Document_periodicity') ,('dbo.Document_periodicity_date') ,('dbo.Document_transfer_method') ,('dbo.Document_type') ,('dbo.DT_cash_register') ,('dbo.DWT_Item_Search_Itk') ,('dbo.DWT_Item_Search_Ittx') ,('dbo.DWT_Item_Search_PHGDSC') ,('dbo.EAS_file_line') ,('dbo.EDI_DTA_entry_link') ,('dbo.Effective_pre_entry_link') ,('dbo.Effective_preliminary_entry') ,('dbo.EMC_payroll_variable') ,('dbo.Employee') ,('dbo.EMS_deposit') ,('dbo.EMSS_DL_link') ,('dbo.Entry') ,('dbo.Entry_key') ,('dbo.Entry_link') ,('dbo.Entry_reconciliation') ,('dbo.Entry_type') ,('dbo.Event') ,('dbo.Event_service') ,('dbo.External_file') ,('dbo.External_file_section') ,('dbo.External_file_section_text') ,('dbo.External_file_text') ,('dbo.Facility') ,('dbo.Family_allowance_account') ,('dbo.Filestream') ,('dbo.Financial_institution') ,('dbo.Financial_relation_account') ,('dbo.Fiscal_year') ,('dbo.Fixed_price') ,('dbo.Form_property_model') ,('dbo.IND_DH_link') ,('dbo.INS_PD_link') ,('dbo.Inter_OU_entry') ,('dbo.Inventory_batch') ,('dbo.Inventory_location') ,('dbo.Inventory_site') ,('dbo.Inventory_type') ,('dbo.Invitation') ,('dbo.Invoicing_method') ,('dbo.IT_category_management') ,('dbo.IT_config_setting') ,('dbo.IT_ITCM_history') ,('dbo.IT_label_print_log') ,('dbo.Item') ,('dbo.Item_attachment') ,('dbo.Item_context') ,('dbo.Item_context_status') ,('dbo.Item_criteria') ,('dbo.Item_dispatch_header') ,('dbo.Item_dispatch_line') ,('dbo.Item_family') ,('dbo.Item_inventory') ,('dbo.Item_key') ,('dbo.Item_link') ,('dbo.Item_location') ,('dbo.Item_purchase') ,('dbo.Item_quantity') ,('dbo.Item_relation_info') ,('dbo.Item_revision') ,('dbo.Item_sale') ,('dbo.Item_seasonal_stock_info') ,('dbo.Item_site') ,('dbo.Item_standard_cost') ,('dbo.Item_status_history') ,('dbo.Item_technical_criteria') ,('dbo.Item_text') ,('dbo.Item_unit_conversion') ,('dbo.Journal') ,('dbo.Language') ,('dbo.Language_text') ,('dbo.LORE_item_ABC_code') ,('dbo.LORE_item_facing') ,('dbo.LORE_rotation_ABC') ,('dbo.LORE_supplying_procedure') ,('dbo.MAGAD_DL_link') ,('dbo.Maintenance_contract') ,('dbo.Manufacturer') ,('dbo.Material_requirement') ,('dbo.MRP_log') ,('dbo.OPT_DH_info') ,('dbo.Organizational_unit') ,('dbo.OU_price_code_priority') ,('dbo.OU_store_history') ,('dbo.OU_user_role') ,('dbo.OUAS_DL_link') ,('dbo.Package_doc_line_link') ,('dbo.Packing_list') ,('dbo.Packing_type') ,('dbo.Payment_input_detail') ,('dbo.Payment_input_header') ,('dbo.Payment_method') ,('dbo.Payment_terms') ,('dbo.Payment_terms_text') ,('dbo.PD_default_address_link') ,('dbo.Periodic_document_model') ,('dbo.Periodicity_master') ,('dbo.PH_APOS_item_status') ,('dbo.PH_Clinical_Check') ,('dbo.PH_Clinical_Check_Text') ,('dbo.PH_Clinical_Check_Type') ,('dbo.PH_Clinical_Check_Type_Text') ,('dbo.PH_custom_insurance_plan') ,('dbo.PH_ins_plan_pattern') ,('dbo.PH_ins_plan_pattern_master') ,('dbo.PH_insurance') ,('dbo.PH_insurance_agreement') ,('dbo.PH_insurance_card') ,('dbo.PH_insurance_card_validation_history') ,('dbo.PH_insurance_group') ,('dbo.PH_insurance_group_link') ,('dbo.PH_insurance_plan') ,('dbo.PH_insurance_tax_link') ,('dbo.PH_item') ,('dbo.PH_item_limitation') ,('dbo.PH_item_regulation_info') ,('dbo.PH_OICM_code') ,('dbo.PH_organizational_unit') ,('dbo.PH_patient') ,('dbo.PH_patient_clinical_check') ,('dbo.PH_patient_tax_link') ,('dbo.PH_payment_receipt') ,('dbo.PH_prescriber') ,('dbo.PH_prescription_header') ,('dbo.PH_prescription_line') ,('dbo.PH_product') ,('dbo.PH_refund_code') ,('dbo.PH_refund_code_relation') ,('dbo.PH_refund_code_text') ,('dbo.PH_sales_import') ,('dbo.PHGD_ACSC') ,('dbo.PHGD_ACXI') ,('dbo.PHGD_Brevier') ,('dbo.PHGD_BrevierText') ,('dbo.PHGD_CODES') ,('dbo.PHGD_CODETXT') ,('dbo.PHGD_CommonStyleSheet') ,('dbo.PHGD_Compendium') ,('dbo.PHGD_CompendiumParagraph') ,('dbo.PHGD_CompendiumText') ,('dbo.PHGD_LIMITATION') ,('dbo.PHGD_LIMITTXT') ,('dbo.PHGD_product_form') ,('dbo.PHGD_SC') ,('dbo.Phone_call_log') ,('dbo.Physical_inventory_detail') ,('dbo.PKD_DL_link') ,('dbo.Pre_cost_entry_master') ,('dbo.Predefined_entry') ,('dbo.Predefined_entry_flow') ,('dbo.Predefined_entry_print_text') ,('dbo.Preliminary_entry') ,('dbo.Preliminary_entry_master') ,('dbo.Price_code') ,('dbo.Price_modifier') ,('dbo.Price_type') ,('dbo.Process_option') ,('dbo.Product_line') ,('dbo.Production_time') ,('dbo.Profit_cost_center') ,('dbo.Profit_cost_center_key') ,('dbo.Profit_cost_type') ,('dbo.Project_entry') ,('dbo.Prospection') ,('dbo.QRCodes') ,('dbo.Reason') ,('dbo.Reason_text') ,('dbo.Registration') ,('dbo.Sales_rep_address_list') ,('dbo.Sales_representative') ,('dbo.Sales_tax_code') ,('dbo.Sales_tax_code_text') ,('dbo.Sales_tax_rate') ,('dbo.Security_custody') ,('dbo.Serial_number') ,('dbo.Serial_number_history') ,('dbo.Shipping_method') ,('dbo.Signboard_DL_link') ,('dbo.SQL_connection') ,('dbo.Standard_cost_param') ,('dbo.Status') ,('dbo.Status_type') ,('dbo.Stock_trans_effective_cost') ,('dbo.Stock_trans_type') ,('dbo.Stock_transaction') ,('dbo.Stock_transaction_master') ,('dbo.Subsidiary') ,('dbo.Supplier') ,('dbo.Swiss_customs_detail') ,('dbo.sysarticles') ,('dbo.sysarticleupdates') ,('dbo.syspublications') ,('dbo.System_site') ,('dbo.Tariff') ,('dbo.Tariff_type') ,('dbo.Task') ,('dbo.Telecom') ,('dbo.Time_period') ,('dbo.Time_period_master') ,('dbo.Title') ,('dbo.Title_text') ,('dbo.Transaction_header') ,('dbo.TriaScan_Document') ,('dbo.TT_Account_Statement') ,('dbo.TT_ACS_dataset') ,('dbo.TT_BOM') ,('dbo.TT_EMC') ,('dbo.TT_EMC_Security') ,('dbo.TT_EPP') ,('dbo.TT_LD_Entry') ,('dbo.TT_OU_advertising_move') ,('dbo.TT_PCA') ,('dbo.TT_PIH_Source_FNRA_Update') ,('dbo.TT_Search_Address') ,('dbo.TT_Search_DH') ,('dbo.TT_Search_DH_Total') ,('dbo.TT_Search_HR_Header') ,('dbo.TT_Serial_Number') ,('dbo.TT_ST') ,('dbo.TT_WKO') ,('dbo.Unit_code') ,('dbo.Unit_code_text') ,('dbo.VAT_period') ,('dbo.Vehicle') ,('dbo.VIP_card_type_link') ,('dbo.Web_service_access') ,('dbo.Web_service_access_text') ,('dbo.Work_order') ,('dbo.Work_order_BOM_location') ,('dbo.Work_order_process') ,('dbo.WSA_connection') ,('dnz.ItemSearch') ,('wkl.AutoExpiryDateRule') ,('wkl.DeliveryNote') ,('wkl.DocumentSignature') ,('wkl.GoodsReceipt') ,('wkl.GoodsReceiptLine') ,('wkl.GoodsReceiptLineDetail') ,('wkl.ItemOrderCondition') ,('wkl.ItemSalesStatistics') ,('wkl.OrderRequest') ,('wkl.POCustomerReference') ,('wkl.PolTransmissionResponse') ,('wkl.PurchaseOrder') ,('wkl.PurchaseOrderLine') ,('wkl.PurchaseOrderLineDetail') ,('wkl.PurchaseReturnLine') ,('wkl.TriggerEvent') ,('wkl.ZoneDeliveryRule') ,('dbo.Contact_person') ,('dbo.Criteria_type_text') ,('dbo.Document_type_text') ,('dbo.Effective_pre_cost_entry') ,('dbo.EMC_payroll_period') ,('dbo.Item_family_text') ,('dbo.Item_group') ,('dbo.Item_manufacturing') ,('dbo.Item_shipping') ,('dbo.JAL_authorized_ACPE') ,('dbo.LAN_app_equivalence') ,('dbo.Machine_time') ,('dbo.Payment_terms_detail') ,('dbo.Payroll_calculation') ,('dbo.PEM_amount_breakdown') ,('dbo.Price_element') ,('dbo.Standard_text') ,('dbo.Standard_text_text') ,('dbo.Status_text') ,('dbo.Swiss_bank_clearing') ,('dbo.Task_key') ,('wkl.GoodsReceiptScanHistory') ,('wkl.PODNLink') ,('wkl.PurchaseReturn') ,('dbo.Account_interest') ,('dbo.Criteria_schema_header') ,('dbo.Item_context_status_text') ,('dbo.Item_context_text') ,('dbo.Item_group_text') ,('dbo.Ledger') ,('dbo.OU_group_link') ,('dbo.PH_ins_plan_refund_link') ,('dbo.PH_item_commercial_rule') ,('dbo.PH_OICM_code_text') ,('dbo.Predefined_entry_rounding') ,('dbo.Print_style') ,('dbo.Remedy') ,('dbo.Standard_unit_conversion') ,('dbo.TT_doc_line_date') ,('wkl.OrderRequestLine') ,('dbo.Address_category_text') ,('dbo.OU_item_link') ,('dbo.TT_TXT_DL') ,('wkl.MissedSale') ,('dbo.Accounting_plan_text') ,('dbo.Address_group_text') ,('dbo.Address_type_text') ,('dbo.CCI_address') ,('dbo.Cost_accounting_type_text') ,('dbo.DBA_change_tracking') ,('dbo.Delivery_code_text') ,('dbo.EDI_DTA_structure') ,('dbo.EDI_DTA_structure_text') ,('dbo.Entry_type_text') ,('dbo.Interco_task_PD_link') ,('dbo.Inventory_type_text') ,('dbo.Invoicing_method_text') ,('dbo.MSpeer_request') ,('dbo.MSpeer_response') ,('dbo.OU_authorized_interco_task') ,('dbo.Packing_type_text') ,('dbo.Payment_method_text') ,('dbo.Periodicity_master_text') ,('dbo.PH_insurance_recommendation') ,('dbo.PH_prescriber_role') ,('dbo.Pharmacy_indicator') ,('dbo.Pre_cost_entry_master_text') ,('dbo.Prelim_entry_master_text') ,('dbo.Price_element_text') ,('dbo.Shipping_method_text') ,('dbo.Signature_schema') ,('dbo.Signature_schema_text') ,('dbo.SP_catalog') ,('dbo.sysschemaarticles') ,('dbo.syssubscriptions') ,('dbo.System_site_SQL_instance') ,('dbo.Tariff_type_text') ,('dbo.VAT_period_text') ,('dbo.Vehicle_text') ,('dbo.DBA_Servers_Monitoring') ,('dbo.EPD_provider') ,('dbo.IT_weighing_category') ,('dbo.Item_price_range') ,('dbo.Item_regulation') ,('dbo.OU_group') ,('dbo.Ph_insurance_history') ,('dbo.PH_std_posology') ,('dbo.PH_tax_history') ,('dbo.PHGD_XI') ,('dbo.PHGD_XIM') ,('dbo.PHGD_XITXT') ,('dbo.Surplus_header') ,('dbo.TT_DL') ,('dbo.Account_ACPE_lock') ,('dbo.LORE_store_opening_days') ,('dbo.LORE_wilson_correction_factor') ,('dbo.Work_order_status_history') ,('dbo.DBA_Mailing_list') ,('dbo.OU_manager') ,('dbo.Work_type') ,('dbo.Agenda') ,('dbo.Alloy_header') ,('dbo.Alloy_header_text') ,('dbo.CCI_ATA') ,('dbo.EDI_DTA') ,('dbo.Payroll_batch') ,('dbo.PHIP_date') ,('dbo.Physical_inventory_master') ,('dbo.Project') ,('dbo.Project_key') ,('dbo.Signboard_contract') ,('dbo.Signboard_per_status_hist') ,('dbo.Signboard_periodicity') ,('dbo.Task_status_history') ,('dbo.Tech_criteria_value') ,('dbo.Tech_criteria_value_text') ,('dbo.Technical_criteria') ,('dbo.Technical_criteria_text') ,('dbo.WKOP_external_reference') ,('dbo.Work_order_cost') ,('dbo.LORE_management_level') ,('dbo.Bmc_batch_type_text') ,('dbo.Profit_cost_center_text') ,('dbo.APS_context_monitor') ,('dbo.Signature_schema_detail') ,('dbo.Status_schema_detail') ,('dbo.PH_invoice_header') ,('dbo.Product_line_text') ,('dbo.DiscountVoucherCondition') ,('dbo.DiscountVoucherLinkOU') ,('dbo.DiscountVoucherText') ,('dbo.LORE_rotation_ABC_detail') ,('dbo.PH_OICM_history') ,('dbo.LORE_evaluation_period') ,('dbo.DVActionDefinition') ,('dbo.Account_group_text') ,('dbo.DVPackageElement') ,('dbo.OU_store_type') ,('dbo.Employment_contract') ,('dbo.SP_catalog_text') ,('dbo.Bmc_application_key_text') ,('dbo.LORE_service_level_rate') ,('dbo.LORE_statistical_period') ,('dbo.LORE_wilson_corr_fact_criteria') ,('dbo.LORE_wilson_purchasing_cost') ,('dbo.Item_price_range_text') ,('dbo.LORE_average_sales_qty') ,('dbo.LORE_poisson_coefficient') ,('dbo.LORE_wilson_interest_rate') ,('dbo.LORE_wilson_logistics_cost') ,('dbo.LORE_z_coefficient') ,('dbo.PD_item_group_link') ,('dbo.Family_technical_criteria') ,('dbo.FTC_authorized_value') ,('dbo.ITTC_history') ,('dbo.TC_authorized_value') ,('dbo.Remedy_text') ,('dbo.Zip_code') ,('dbo.AC_profit_cost_type_link') ,('dbo.Acc_pre_cost_entry_link') ,('dbo.ACG_profit_cost_type_link') ,('dbo.Cost_acc_plausibility') ,('dbo.Profit_cost_type_key') ,('dbo.Profit_cost_type_text') ,('dbo.MAG_ad') ,('dbo.TT_DH_generation') ,('dbo.TT_DL_generation') ,('dbo.LORE_calculation_log') ,('dbo.Item_text_planned') ,('dbo.Serial_number_status_text') ,('dbo.PH_PHIPM_text') ,('dbo.EAS_structure_text') ,('dbo.Job_function_text') ,('dbo.IT_weighing_category_text') ,('dbo.Item_group_def_accounting') ,('dbo.Bmc_context') ,('dbo.Calendar_header') ,('dbo.Department') ,('dbo.Periodicity_type') ,('dbo.PH_spec_tariff_addr_link') ,('dbo.Remark_type') ,('dbo.Report') ,('dbo.SSSI_OU_link') ,('dbo.Standard_text_type') ,('dbo.System_site_transfer') ,('dbo.VIP_card') ,('AP.InventoryScan') ,('dbo.Account_balance') ,('dbo.Account_credit_insurance') ,('dbo.Account_structure') ,('dbo.Accounting_balance') ,('dbo.Active_directory_user') ,('dbo.Address_item_link') ,('dbo.Address_remark') ,('dbo.Alloy_pre_transaction') ,('dbo.Alloy_pre_transaction_text') ,('dbo.Alloy_processing_cost') ,('dbo.Application_default') ,('dbo.Asset_group') ,('dbo.Bmc_context_text') ,('dbo.Bmc_task_text') ,('dbo.Brand_AD_link') ,('dbo.Brand_OU_link') ,('dbo.Button_text') ,('dbo.Calendar_header_text') ,('dbo.CCI_item') ,('dbo.CR_receipt_input_schema') ,('dbo.CSH_text') ,('dbo.Currency_account') ,('dbo.Delivery_cost_detail') ,('dbo.DVCouponActionDefinitionText') ,('dbo.EFT_OW_pre_entry') ,('dbo.EMC_payment_method') ,('dbo.Ems_stay') ,('dbo.Family_allowance_journal') ,('dbo.HR_language_skill') ,('dbo.HR_skill') ,('dbo.HR_training') ,('dbo.Incident_detail') ,('dbo.Insurance_network') ,('dbo.Insurance_network_text') ,('dbo.INT_PD_link') ,('dbo.Inter_OU_pre_entry') ,('dbo.IT_categ_management_text') ,('dbo.IT_change_request') ,('dbo.ITCAT_IT_link') ,('dbo.ITCHR_item_link') ,('dbo.Item_statistics') ,('dbo.Item_terms') ,('dbo.OU_advertising_space') ,('dbo.Payment_proposal_batch') ,('dbo.Payroll_employee_profile') ,('dbo.Payroll_heading_specs') ,('dbo.Payroll_profile_detail') ,('dbo.PCA_payment_method') ,('dbo.PD_minimum_amount') ,('dbo.Periodicity_detail') ,('dbo.Periodicity_type_text') ,('dbo.PH_insurance_group_text') ,('dbo.PH_item_insurance_link') ,('dbo.PH_spec_tariff_detail') ,('dbo.PH_spec_tariff_master_txt') ,('dbo.Point_of_sale') ,('dbo.Pre_cost_entry') ,('dbo.Price_code_text') ,('dbo.Print_style_text') ,('dbo.Prospection_amount') ,('dbo.Remark_type_text') ,('dbo.Reminder_method') ,('dbo.Standard_text_type_text') ,('dbo.Status_schema_header_text') ,('dbo.Status_type_text') ,('dbo.Stock_trans_type_text') ,('dbo.Variable_price') ,('dbo.VIP_card_type') ,('dbo.Work_type_text') ,('dbo.Bank_card') ,('dbo.Bank_card_detail') ,('dbo.BVR_type') ,('dbo.DVACSpecificTargetItem') ,('dbo.DVCouponActionDefinition') ,('dbo.DVCouponActionDefPrinting') ,('dbo.Item_LORE_min_max') ,('dbo.Numerary_value') ,('dbo.PH_spec_tariff_master') ,('dbo.sysarticlecolumns') ,('dbo.APS_synchro_journal') ,('dbo.Department_text') ,('dbo.Interco_task') ,('dbo.Marketing_type') ,('dbo.Marketing_type_text') ,('dbo.PD_pre_cost_entry_link') ,('dbo.Registration_booth_link') ,('dbo.Security_group') ,('dbo.Security_group_text') ,('dbo.Terms_schema_detail') ,('dbo.Terms_schema_header') ,('dbo.Terms_schema_header_text') ,('dbo.Acc_structure_master_text') ,('dbo.Account_interest_rate') ,('dbo.Account_interest_text') ,('dbo.Account_PD_link') ,('dbo.Account_structure_master') ,('dbo.Account_structure_text') ,('dbo.Accounting_balance_detail') ,('dbo.ACPE_weighting_detail') ,('dbo.ACPE_weighting_master') ,('dbo.ACPE_weighting_master_text') ,('dbo.ACS_account_list') ,('dbo.ACS_layout_detail') ,('dbo.ACS_layout_detail_text') ,('dbo.ACS_layout_master_text') ,('dbo.Activity_supplement_text') ,('dbo.Activity_text') ,('dbo.Activity_type_text') ,('dbo.Address_distance_chart') ,('dbo.Address_salutation') ,('dbo.Advert_support_target') ,('dbo.Advert_support_type_OU_cap') ,('dbo.Advert_support_type_text') ,('dbo.Alloy_element_text') ,('dbo.Alloy_pre_transaction_link') ,('dbo.APS_context_monitor_log') ,('dbo.APS_tech_criteria_type_text') ,('dbo.Asset_deprec_method_period') ,('dbo.Asset_family_text') ,('dbo.Asset_group_text') ,('dbo.Asset_location_text') ,('dbo.Assortment_text') ,('dbo.ATT_cust_list_column_text') ,('dbo.ATT_customized_list_text') ,('dbo.ATT_time_period_constraint') ,('dbo.Bmc_authorized_task') ,('dbo.Bmc_group_level_security') ,('dbo.Bmc_license_task_link') ,('dbo.BMC_task_log') ,('dbo.BOM_rule_text') ,('dbo.BOM_rule_type_text') ,('dbo.Booth') ,('dbo.Budget_type') ,('dbo.Budget_type_text') ,('dbo.BVR_header') ,('dbo.Calendar_detail') ,('dbo.Cash_report_header') ,('dbo.CCI_PD_deposit_code') ,('dbo.CCI_reminder') ,('dbo.CLK_group_text') ,('dbo.Clocking_key') ,('dbo.Clocking_message_text') ,('dbo.Clocking_terminal') ,('dbo.CNCI_addr') ,('dbo.Comm_price_master_text') ,('dbo.Contract_daily_time_detail') ,('dbo.Contract_time_table_date') ,('dbo.Contract_time_table_detail') ,('dbo.CR_receipt_POS') ,('dbo.Credit_card_company') ,('dbo.Custom_export_licence_text') ,('dbo.Delivery_cost_text') ,('dbo.Depreciation_method') ,('dbo.Depreciation_method_period') ,('dbo.DH_signature') ,('dbo.Document_copy') ,('dbo.DT_address') ,('dbo.DT_document_header') ,('dbo.DT_registration_address') ,('dbo.EAS_APS_address_link') ,('dbo.EAS_APS_op_link_text') ,('dbo.EAS_file_header') ,('dbo.Effective_time') ,('dbo.EFT_OW_method') ,('dbo.EFT_OW_method_text') ,('dbo.EFT_terminal_OU_link') ,('dbo.EFT_terminal_text') ,('dbo.Element_account') ,('dbo.EMC_termination_reason_text') ,('dbo.EMC_termination_type_text') ,('dbo.Employee_work_plan') ,('dbo.Employment_contract_history') ,('dbo.Ems_address') ,('dbo.EPP_status_history') ,('dbo.ERP_role_mapping') ,('dbo.ERP_role_text') ,('dbo.Ethnic_group_text') ,('dbo.Event_catalogue') ,('dbo.Event_contact_address') ,('dbo.Event_registration') ,('dbo.External_preliminary_entry') ,('dbo.FA_account_periodicity') ,('dbo.FA_RAFAM_type_text') ,('dbo.Facility_address_link') ,('dbo.Family_allowance_history') ,('dbo.FUN_OUSH_link') ,('dbo.Hotline') ,('dbo.HR_certificate_text') ,('dbo.HR_header') ,('dbo.HR_prof_experience') ,('dbo.HR_skill_level_text') ,('dbo.HR_skill_type_text') ,('dbo.HR_training_course_text') ,('dbo.HR_training_field_text') ,('dbo.HR_training_type_text') ,('dbo.Incident_header') ,('dbo.Incident_type') ,('dbo.Incident_type_text') ,('dbo.IND_status_history') ,('dbo.Insurance_policy') ,('dbo.Inter_OU_pre_ET_master_text') ,('dbo.Interco_task_text') ,('dbo.ITCAT_OUST_link') ,('dbo.ITCHR_status_history') ,('dbo.Item_catalog_text') ,('dbo.Knowledge_base') ,('dbo.Knowledge_category_text') ,('dbo.Leasing') ,('dbo.Ledger_text') ,('dbo.Machine') ,('dbo.Machine_text') ,('dbo.MAG_ad_status_history') ,('dbo.MAG_ad_type_text') ,('dbo.MAG_status_history') ,('dbo.Magazine') ,('dbo.Magazine_type') ,('dbo.Magazine_type_text') ,('dbo.Maintenance') ,('dbo.Margin_class_text') ,('dbo.Margin_factor_master') ,('dbo.Margin_factor_master_text') ,('dbo.Marital_status') ,('dbo.Marketing_action_detail') ,('dbo.Marketing_activity_header') ,('dbo.Occupation_text') ,('dbo.OPT_measure') ,('dbo.OU_authorized_PD') ,('dbo.OU_group_text') ,('dbo.OU_store_type_budget') ,('dbo.OU_store_type_text') ,('dbo.Payroll_heading') ,('dbo.Payroll_heading_text') ,('dbo.Payroll_parameters') ,('dbo.Payroll_period_master_text') ,('dbo.Payroll_period_text') ,('dbo.Payroll_period_type_text') ,('dbo.Payroll_profile_master_text') ,('dbo.Payroll_scale_master') ,('dbo.Payroll_scale_master_text') ,('dbo.PD_link') ,('dbo.PH_insurance_supplement') ,('dbo.PH_posology_code_text') ,('dbo.PH_Prescriber_ins_link') ,('dbo.PH_std_posology_text') ,('dbo.PJ_pre_cost_entry_link') ,('dbo.PJS_layout_detail_text') ,('dbo.PJS_layout_master_text') ,('dbo.PPB_address_selection') ,('dbo.PPB_OU_selection') ,('dbo.PR_certificate_layout_text') ,('dbo.PR_cust_list_column_text') ,('dbo.PR_customized_list_text') ,('dbo.PR_global_value_link_text') ,('dbo.PR_official_list_col_text') ,('dbo.PR_official_list_text') ,('dbo.PR_periodicity_type') ,('dbo.PR_periodicity_type_text') ,('dbo.PRCH_status_history') ,('dbo.Pre_entry_link') ,('dbo.Premise_text') ,('dbo.Prescription') ,('dbo.PRH_boundary') ,('dbo.PRH_boundary_text') ,('dbo.PRH_complement_text') ,('dbo.Price_type_text') ,('dbo.Pro_svc_psbl_answer_text') ,('dbo.Pro_svc_question_text') ,('dbo.Process_overlap_text') ,('dbo.Process_sub_contractor') ,('dbo.Project_address_link') ,('dbo.Project_status_history') ,('dbo.Project_structure') ,('dbo.Project_structure_text') ,('dbo.Prospection_reason') ,('dbo.Quantity_formula_master_txt') ,('dbo.Receipt_summary') ,('dbo.REG_status_history') ,('dbo.Religion_text') ,('dbo.Repository_update_log') ,('dbo.Room_category_text') ,('dbo.Salary_grade_text') ,('dbo.Sector_text') ,('dbo.Signboard_location') ,('dbo.Signboard_type_text') ,('dbo.STASD_event') ,('dbo.Statistic_OU_link') ,('dbo.Status_schema') ,('dbo.STT_PD_link') ,('dbo.Surplus_header_text') ,('dbo.Swiss_EMCH_supplement') ,('dbo.Swiss_payroll_parameters') ,('dbo.Symptom_text') ,('dbo.System_email') ,('dbo.System_site_link_auth') ,('dbo.System_site_SUB_link') ,('dbo.Task_address_link') ,('dbo.Task_progress_history') ,('dbo.Time_period_master_text') ,('dbo.Time_period_text') ,('dbo.Time_sheet_special_rate') ,('dbo.Time_table_schema_date') ,('dbo.Time_table_schema_detail') ,('dbo.Time_table_schema_text') ,('dbo.Time_table_type_text') ,('dbo.TK_pre_cost_entry_link') ,('dbo.Vendor_managed_inv_text') ,('dbo.Vendor_managed_inventory') ,('dbo.VIP_card_type_text') ,('dbo.VIPCT_marketing_type') ,('dbo.Weekly_schema_header') ,('dbo.WKOP_assignment') ,('dbo.Work_center') ,('dbo.Work_center_text') ,('dbo.Work_location') ,('dbo.Work_location_text') ,('dbo.Work_order_process_qty') ,('dbo.Work_permit') ,('dbo.Work_sheet_header') ,('dbo.Workplace') ,('dbo.Workplace_text') ,('dbo.ZIP_distance_chart') ,('wkl.PolLinkLog') ,('wkl.POMergeLog') ,('dbo.Serial_number_status') ,('repl.ArticleConfiguration') ,('dbo.EAS_structure') ,('dbo.Job_function') ,('dbo.Sub_contractor_terms') ,('dbo.Address_merge_prevalidation') ,('dbo.TT_Physical_Inventory_Detail_Load') ,('dbo.TT_Physical_Inventory_Detail_Load_Archived') ,('dbo.ACS_profit_cost_type_list') ,('dbo.Activity') ,('dbo.Activity_prod_rate_default') ,('dbo.Asset_history') ,('dbo.Assortment_item_link') ,('dbo.Cash_report_line') ,('dbo.Commercial_price_detail') ,('dbo.Criteria_schema_detail') ,('dbo.Criteria_schema_values') ,('dbo.Delivery_cost_DC_link') ,('dbo.DH_pre_calc_quantity') ,('dbo.DiscountVoucher_FS_link') ,('dbo.EMC_criteria') ,('dbo.EMC_loan') ,('dbo.EMC_multi_profile') ,('dbo.EMC_periodicity') ,('dbo.Ems_room') ,('dbo.Event_catalogue_link') ,('dbo.FP_unit_price_breakdown') ,('dbo.HR_evaluation_detail') ,('dbo.HR_evaluation_master') ,('dbo.HR_training_attendee') ,('dbo.HR_warning') ,('dbo.ITCHR_consequence') ,('dbo.ITCOSTA_CR_link') ,('dbo.Item_alloy') ,('dbo.Item_process') ,('dbo.Item_statistics_monthly') ,('dbo.Item_statistics_yearly') ,('dbo.MAFAM_item_link') ,('dbo.MAG_ad_item') ,('dbo.MAG_ad_type') ,('dbo.Margin_factor_detail') ,('dbo.OPT_task_info') ,('dbo.Package_detail') ,('dbo.Package_header') ,('dbo.Payment_proposal_bank') ,('dbo.Payroll_scale_detail') ,('dbo.PCC_totalizator_link') ,('dbo.PCT_totalizator_link') ,('dbo.PHID_alloy') ,('dbo.PJ_item_link') ,('dbo.PPB_payment_method') ,('dbo.PR_certificate_detail') ,('dbo.PRH_boundary_history') ,('dbo.PRH_item_link') ,('dbo.Pro_svc_question') ,('dbo.Process_line') ,('dbo.Project_criteria') ,('dbo.Prospection_criteria') ,('dbo.Salary_grade_history') ,('dbo.Signboard') ,('dbo.Signboard_type') ,('dbo.Standard_cost_rate') ,('dbo.Stock_transaction_master_log') ,('dbo.Task_criteria') ,('dbo.Time_sheet_rate') ,('dbo.Transaction_line') ,('dbo.VIP_card_issue_type') ,('dbo.VIP_deny_discount') ,('atl.Change_tracking_history') ,('dbo.DBA_change_tracking_template') ,('dbo.DBA_change_tracking_version') ,('dbo.MSpeer_conflictdetectionconfigrequest') ,('dbo.MSpeer_conflictdetectionconfigresponse') ,('dbo.MSpeer_lsns') ,('dbo.MSpeer_originatorid_history') ,('dbo.MSpeer_topologyrequest') ,('dbo.MSpeer_topologyresponse') ,('dbo.MSpub_identity_range') ,('repl.ArticleColumnException') ,('repl.PublicationConfiguration') ,('dbo.Premise') ,('dbo.TT_LORE_Label_Printing') ,('dbo.Button') ,('dbo.Status_schema_header') ,('upd.DatabaseHistory') ,('upd.MigrationScriptHistory') ,('upd.RunOnceScriptHistory') ,('dbo.Object_merge_log') ,('dbo.TT_XML_goods_receiving') ,('dbo.TT_IT_monthly_stat') ,('dbo.TT_PH_purchase_condition') ,('dbo.TT_PH_purchase_price') ,('dbo.Quantity_formula_master') ,('dbo.MAGAD_technical_criteria') ,('dbo.Linked_document') ,('dbo.Advert_support_type') ,('dbo.EDI_DTA_PCA_payment_link') ,('dbo.EDI_DTA_PIH_link') ,('dbo.TT_Item_seasonal_stock_info') ,('dbo.RAFAM_notification') ,('dbo.Ethnic_group') ,('dbo.Religion') ,('dbo.TT_Export_ACBARCODE') ,('dbo.TT_PH_Purchase_Physician') ,('dbo.TT_Bmc_application_default_backup_vesta_migration') ,('dbo.Bmc_application_default_backup_vesta_migration') ,('vesta.Commvault_last_backup') ,('dbo.TT_item_availability_check') ,('dbo.TT_PH_purchase_dashboard') ,('dbo.Bank_card_transaction') ,('dbo.sysreplservers') ,('dbo.TT_LORE_wilson_correction_factor') ,('dbo.Operation') ,('dbo.Operation_role') ,('dbo.Loyalty_card') ,('dbo.Margin_class') ,('dbo.EFT_terminal') ,('AP.GlobalBlueRefund') ,('dam.AMR_count_config') ,('dbo.Statistic') ,('dbo.DBA_change_tracking_DWH') ,('dbo.User_card') ,('dam.MissingData') ,('dbo.Pro_svc_psbl_answer') ,('dbo.Asset_family') ,('dbo.Asset_location') ,('dbo.TT_Item_large_generic_sequence') ,('dbo.DT_registration') ,('dbo.Email_pattern') ,('dbo.Item_catalog') ,('dbo.AX_user_data_area_mapping') ,('dbo.ERP_role') ,('dbo.ZZ_DVE_MON_TRACKING') ,('dbo.TT_ITDH_Send') ,('dbo.TT_extraction_timestamp') ,('dbo.TT_fixed_price_pricing') ,('dbo.TT_Synchro_Item_List') ,('dbo.Pro_svc_session') ,('dbo.Pro_svc_session_answer') ,('dbo.PR_official_list') ,('dbo.PR_official_list_column') ,('dbo.Swiss_AVS_structure') ,('dbo.TT_Item_Dispatch_Load') ,('dbo.ACS_layout_master') ,('dbo.Activity_type') ,('dbo.Assortment') ,('dbo.ATT_customized_list') ,('dbo.BOM_header') ,('dbo.BOM_rule_type') ,('dbo.CLK_group') ,('dbo.Commercial_price_master') ,('dbo.Delivery_cost') ,('dbo.DT_device') ,('dbo.Family_allowance_tariff') ,('dbo.Inter_OU_pre_ET_master') ,('dbo.Interco_structure') ,('dbo.Interco_structure_target') ,('dbo.Payroll_period_master') ,('dbo.Payroll_profile_master') ,('dbo.PJS_layout_master') ,('dbo.PR_certificate_layout') ,('dbo.PR_customized_list') ,('dbo.PRH_complement') ,('dbo.Process_header') ,('dbo.PROL_column_link') ,('dbo.PRPET_conversion') ,('dbo.Room_category') ,('dbo.Salary_grade') ,('dbo.Sector') ,('dbo.SUB_RAFAM_parameter') ,('dbo.Time_table_schema') ,('dbo.Time_table_type') ,('dbo.ATT_totalizator_link') ,('dbo.MSdynamicsnapshotviews') ,('dbo.sysmergepublications') ,('dbo.sysmergesubscriptions') ,('dbo.sysmergearticles') ,('dbo.sysmergeschemaarticles') ,('dbo.HR_training_course') ,('dbo.Card') ,('dbo.MSmerge_replinfo') ,('wkl.ActiveStockEventLog') ,('dbo.PH_posology_code') ,('dbo.Material_requirement_link') ,('dbo.MAG_page') ,('dbo.TT_item_criteria') ,('dbo.TT_ITCAT_OUST_link') ,('dbo.Signboard_location_hist') ,('dbo.TT_Item_Fixed_Price') ,('dbo.Advert_support') ,('dbo.TT_Address_Extraction') ,('dbo.TT_Item_Popup_Text') ,('dbo.TT_Item_Popup_Text_Overlap') ,('dbo.TT_signboard_contract_invoicing') ,('dbo.OUAS_technical_criteria') ,('dbo.TT_Item_Status') ,('dbo.TT_Export_S13') ,('dbo.TT_LD_Fixed_Price') ,('dbo.discountvouchercondition_sav') ,('dbo.TT_DWH_discount_voucher') ,('dbo.DT_document_line') ,('dbo.price_code_17_2') ,('dbo.TT_fusion_address_key') ,('dbo.TT_fusion_fixed_price_II') ,('dbo.TT_Fusion_Item_key') ,('dbo.TT_fusion_Supplier') ,('dbo.TT_item_20171101') ,('dbo.TT_Item_Relation_Info') ,('dbo.TT_src_item_key') ,('dbo.APS_tech_criteria_type') )x(tblNameUsed) --fetched from the Excel posted by Muhaemed Besic INSERT INTO @toAnswer ([fqdn]) SELECT y.tableName FROM( VALUES ('AP.SaleLoyalty') ,('AP.ScannedDocument') ,('AP.StarcardValidity') ,('dam.AMR_count_config') ,('dam.HashValueUniqueIndexGuid') ,('dam.HashValueUniqueIndexInt') ,('dam.MissingData') ,('dam.MonitorTableHash') ,('dbo.Acc_structure_master_text') ,('dbo.Account_ACPE_lock') ,('dbo.Account_balance') ,('dbo.Account_credit_insurance') ,('dbo.Account_interest') ,('dbo.Account_interest_rate') ,('dbo.Account_interest_text') ,('dbo.Account_PD_link') ,('dbo.Account_structure') ,('dbo.Account_structure_master') ,('dbo.Account_structure_text') ,('dbo.Accounting_balance') ,('dbo.Accounting_balance_detail') ,('dbo.ACG_pre_cost_entry_link') ,('dbo.ACG_profit_cost_type_link') ,('dbo.ACPE_weighting_detail') ,('dbo.ACPE_weighting_master') ,('dbo.ACPE_weighting_master_text') ,('dbo.ACS_account_list') ,('dbo.ACS_layout_detail') ,('dbo.ACS_layout_detail_text') ,('dbo.ACS_layout_master') ,('dbo.ACS_layout_master_text') ,('dbo.ACS_profit_cost_type_list') ,('dbo.ACS_totalizator_link') ,('dbo.Activity') ,('dbo.Activity_prod_rate_default') ,('dbo.Activity_supplement') ,('dbo.Activity_supplement_text') ,('dbo.Activity_text') ,('dbo.Activity_type') ,('dbo.Activity_type_text') ,('dbo.Address_contact_person_list') ,('dbo.Address_distance_chart') ,('dbo.Address_invitation') ,('dbo.Address_invoicing_block') ,('dbo.Address_item_link') ,('dbo.Address_salutation') ,('dbo.Advert_support') ,('dbo.Advert_support_target') ,('dbo.Advert_support_type') ,('dbo.Advert_support_type_OU_cap') ,('dbo.Advert_support_type_text') ,('dbo.AGD_DL_link') ,('dbo.Alloy_detail') ,('dbo.Alloy_element') ,('dbo.Alloy_element_quantity') ,('dbo.Alloy_element_text') ,('dbo.Alloy_header') ,('dbo.Alloy_header_text') ,('dbo.Alloy_pre_transaction') ,('dbo.Alloy_pre_transaction_link') ,('dbo.Alloy_pre_transaction_text') ,('dbo.Alloy_processing_cost') ,('dbo.Alloy_transaction') ,('dbo.Application_default') ,('dbo.APS_context_monitor') ,('dbo.APS_context_monitor_log') ,('dbo.APS_synchro_journal') ,('dbo.APS_tech_criteria_type') ,('dbo.APS_tech_criteria_type_text') ,('dbo.ASDP_detail') ,('dbo.Asset') ,('dbo.Asset_deprec_method_period') ,('dbo.Asset_family') ,('dbo.Asset_family_text') ,('dbo.Asset_group') ,('dbo.Asset_group_text') ,('dbo.Asset_history') ,('dbo.Asset_insurance') ,('dbo.Asset_investment_history') ,('dbo.Asset_leasing') ,('dbo.Asset_location') ,('dbo.Asset_location_text') ,('dbo.Asset_maintenance') ,('dbo.Assortment') ,('dbo.Assortment_item_link') ,('dbo.Assortment_text') ,('dbo.ATS_time_period_balance') ,('dbo.ATT_cust_list_column') ,('dbo.ATT_cust_list_column_text') ,('dbo.ATT_customized_list') ,('dbo.ATT_customized_list_text') ,('dbo.ATT_list_column_link') ,('dbo.ATT_time_period_balance') ,('dbo.ATT_time_period_constraint') ,('dbo.ATT_totalizator_link') ,('dbo.AX_item_mappings_rules') ,('dbo.AX_user_data_area_mapping') ,('dbo.Bmc_authorized_task') ,('dbo.Bmc_group_level_security') ,('dbo.Bmc_license') ,('dbo.Bmc_license_task_link') ,('dbo.Bmc_system') ,('dbo.BMC_task_log') ,('dbo.Bmc_task_text') ,('dbo.BMH_rule_type_link') ,('dbo.BML_rule_link') ,('dbo.BMOH_formula_variable') ,('dbo.BMOH_selected_rule') ,('dbo.BOM_header') ,('dbo.BOM_line') ,('dbo.BOM_location') ,('dbo.BOM_option_header') ,('dbo.BOM_revision') ,('dbo.BOM_rule') ,('dbo.BOM_rule_text') ,('dbo.BOM_rule_type') ,('dbo.BOM_rule_type_text') ,('dbo.Booth') ,('dbo.Brand_AD_link') ,('dbo.Brand_OU_link') ,('dbo.Budget_type') ,('dbo.Budget_type_text') ,('dbo.Button') ,('dbo.Button_text') ,('dbo.Calendar_detail') ,('dbo.Card') ,('dbo.CCI_ATA_guarantee') ,('dbo.CLK_group') ,('dbo.CLK_group_text') ,('dbo.CLK_user_interface') ,('dbo.Clocking') ,('dbo.Clocking_key') ,('dbo.Clocking_message') ,('dbo.Clocking_message_text') ,('dbo.Clocking_summary') ,('dbo.Clocking_terminal') ,('dbo.Clocking_terminal_profile') ,('dbo.CLT_authorized_CLKG') ,('dbo.CLTP_schedule') ,('dbo.CLTP_user_interface') ,('dbo.CNCI_addr') ,('dbo.Comm_price_master_text') ,('dbo.Commercial_price_detail') ,('dbo.Commercial_price_master') ,('dbo.Contract_daily_time') ,('dbo.Contract_daily_time_detail') ,('dbo.Contract_time_adjustment') ,('dbo.Contract_time_table_date') ,('dbo.Contract_time_table_detail') ,('dbo.Contract_time_table_header') ,('dbo.Cost_acc_plausibility') ,('dbo.CR_receipt_detail') ,('dbo.CR_receipt_input_schema') ,('dbo.CR_receipt_master') ,('dbo.CR_receipt_POS') ,('dbo.Credit_card_company') ,('dbo.Criteria_schema_detail') ,('dbo.Criteria_schema_values') ,('dbo.CSH_text') ,('dbo.Currency_account') ,('dbo.CUST_ITCOSTA_Spaceman_conversion') ,('dbo.Custom_export_licence') ,('dbo.Custom_export_licence_text') ,('dbo.Customer_card') ,('dbo.DBA_change_tracking_DWH') ,('dbo.Deleted_Lore_Item_Facing') ,('dbo.Delivery_cost') ,('dbo.Delivery_cost_DC_link') ,('dbo.Delivery_cost_detail') ,('dbo.Delivery_cost_text') ,('dbo.Department') ,('dbo.Department_text') ,('dbo.Depreciation_method') ,('dbo.Depreciation_method_period') ,('dbo.DH_customer_card_link') ,('dbo.DH_facility_link') ,('dbo.DH_pre_calc_header') ,('dbo.DH_pre_calc_quantity') ,('dbo.DH_pre_calc_surplus') ,('dbo.DH_signature') ,('dbo.DiscountVoucher_FS_link') ,('dbo.DL_alloy_batch') ,('dbo.DL_BML_link') ,('dbo.DL_criteria') ,('dbo.DL_planning') ,('dbo.DL_pre_calc_material') ,('dbo.DL_pre_calc_process_line') ,('dbo.DL_quantity_formula') ,('dbo.DL_unit_price_breakdown') ,('dbo.DL_WKOP_link') ,('dbo.Doc_header_customs_info') ,('dbo.Document_copy') ,('dbo.Document_header_revision') ,('dbo.Document_header_text') ,('dbo.Document_periodicity') ,('dbo.Document_periodicity_date') ,('dbo.DT_address') ,('dbo.DT_cash_register') ,('dbo.DT_device') ,('dbo.DT_document_header') ,('dbo.DT_document_line') ,('dbo.DT_registration') ,('dbo.DT_registration_address') ,('dbo.dtproperties') ,('dbo.EAS_APS_address_link') ,('dbo.EAS_APS_op_link_text') ,('dbo.EAS_APS_operation_link') ,('dbo.EAS_file_header') ,('dbo.EAS_file_line') ,('dbo.EAS_structure') ,('dbo.EAS_structure_operation') ,('dbo.EAS_structure_text') ,('dbo.EAS_structure_trigger') ,('dbo.EDI_DTA') ,('dbo.EDI_DTA_entry_link') ,('dbo.EDI_DTA_PCA_payment_link') ,('dbo.EDI_DTA_PIH_link') ,('dbo.EDI_DTA_structure') ,('dbo.EDI_DTA_structure_text') ,('dbo.Effective_pre_cost_entry') ,('dbo.Effective_pre_entry_link') ,('dbo.Effective_time') ,('dbo.EFT_OW_method') ,('dbo.EFT_OW_method_text') ,('dbo.EFT_OW_pre_entry') ,('dbo.EFT_OW_rule') ,('dbo.EFT_terminal') ,('dbo.EFT_terminal_OU_link') ,('dbo.EFT_terminal_text') ,('dbo.Element_account') ,('dbo.Element_transaction') ,('dbo.Email_pattern') ,('dbo.EMC_absence') ,('dbo.EMC_certificate_layout') ,('dbo.EMC_criteria') ,('dbo.EMC_loan') ,('dbo.EMC_multi_profile') ,('dbo.EMC_payment_method') ,('dbo.EMC_payroll_period') ,('dbo.EMC_payroll_variable') ,('dbo.EMC_periodicity') ,('dbo.EMC_termination_reason') ,('dbo.EMC_termination_reason_text') ,('dbo.EMC_termination_type') ,('dbo.EMC_termination_type_text') ,('dbo.EMCH_payroll_period_link') ,('dbo.Employee') ,('dbo.Employee_work_plan') ,('dbo.Employment_contract') ,('dbo.Employment_contract_history') ,('dbo.Ems_address') ,('dbo.EMS_deposit') ,('dbo.Ems_room') ,('dbo.Ems_stay') ,('dbo.EMSS_DL_link') ,('dbo.Entry_key') ,('dbo.EPP_status_history') ,('dbo.ERP_role') ,('dbo.ERP_role_mapping') ,('dbo.ERP_role_text') ,('dbo.Ethnic_group') ,('dbo.Ethnic_group_text') ,('dbo.Event') ,('dbo.Event_catalogue') ,('dbo.Event_catalogue_link') ,('dbo.Event_contact_address') ,('dbo.Event_premise') ,('dbo.Event_registration') ,('dbo.Event_sector') ,('dbo.Event_service') ,('dbo.External_entry') ,('dbo.External_file') ,('dbo.External_file_section') ,('dbo.External_file_section_text') ,('dbo.External_file_text') ,('dbo.External_preliminary_entry') ,('dbo.FA_account_periodicity') ,('dbo.FA_RAFAM_type') ,('dbo.FA_RAFAM_type_text') ,('dbo.Facility') ,('dbo.Facility_address_link') ,('dbo.Facility_technical_criteria') ,('dbo.Family_allowance') ,('dbo.Family_allowance_account') ,('dbo.Family_allowance_history') ,('dbo.Family_allowance_journal') ,('dbo.Family_allowance_tariff') ,('dbo.Family_technical_criteria') ,('dbo.FP_unit_price_breakdown') ,('dbo.FTC_authorized_value') ,('dbo.FUN_OUSH_link') ,('dbo.Hotline') ,('dbo.HR_certificate') ,('dbo.HR_certificate_text') ,('dbo.HR_evaluation_detail') ,('dbo.HR_evaluation_master') ,('dbo.HR_header') ,('dbo.HR_language_skill') ,('dbo.HR_prof_experience') ,('dbo.HR_skill') ,('dbo.HR_skill_level') ,('dbo.HR_skill_level_text') ,('dbo.HR_skill_type') ,('dbo.HR_skill_type_text') ,('dbo.HR_training') ,('dbo.HR_training_attendee') ,('dbo.HR_training_course') ,('dbo.HR_training_course_text') ,('dbo.HR_training_field') ,('dbo.HR_training_field_text') ,('dbo.HR_training_type') ,('dbo.HR_training_type_text') ,('dbo.HR_warning') ,('dbo.Incident_detail') ,('dbo.Incident_header') ,('dbo.Incident_type') ,('dbo.Incident_type_text') ,('dbo.IND_DH_link') ,('dbo.IND_status_history') ,('dbo.INS_PD_link') ,('dbo.Insurance_policy') ,('dbo.INT_PD_link') ,('dbo.Inter_OU_entry') ,('dbo.Inter_OU_pre_entry') ,('dbo.Inter_OU_pre_ET_master') ,('dbo.Inter_OU_pre_ET_master_text') ,('dbo.Interco_structure') ,('dbo.Interco_structure_target') ,('dbo.Interco_synchronization') ,('dbo.Invitation') ,('dbo.IT_change_request') ,('dbo.IT_ITCM_history') ,('dbo.IT_weighing_category') ,('dbo.IT_weighing_category_text') ,('dbo.ITCAT_IT_link') ,('dbo.ITCAT_OUST_link') ,('dbo.ITCHR_consequence') ,('dbo.ITCHR_item_link') ,('dbo.ITCHR_status_history') ,('dbo.ITCOSTA_CR_link') ,('dbo.Item_alloy') ,('dbo.Item_alloy_quantity') ,('dbo.Item_catalog') ,('dbo.Item_catalog_text') ,('dbo.Item_dispatch_header') ,('dbo.Item_dispatch_line') ,('dbo.Item_group_def_accounting') ,('dbo.Item_location') ,('dbo.Item_manufacturing') ,('dbo.Item_process') ,('dbo.Item_statistics') ,('dbo.Item_statistics_monthly') ,('dbo.Item_statistics_yearly') ,('dbo.Item_status_history') ,('dbo.Item_terms') ,('dbo.Item_text_planned') ,('dbo.ITTC_history') ,('dbo.Job_function') ,('dbo.Job_function_text') ,('dbo.Knowledge_base') ,('dbo.Knowledge_base_category') ,('dbo.Knowledge_base_key') ,('dbo.Knowledge_category') ,('dbo.Knowledge_category_text') ,('dbo.Leasing') ,('dbo.Ledger') ,('dbo.Ledger_text') ,('dbo.Linked_document') ,('dbo.LORE_wilson_corr_fact_criteria') ,('dbo.Machine') ,('dbo.Machine_downtime') ,('dbo.Machine_text') ,('dbo.Machine_time') ,('dbo.MAFAM_item_link') ,('dbo.MAG_ad') ,('dbo.MAG_ad_item') ,('dbo.MAG_ad_status_history') ,('dbo.MAG_ad_type') ,('dbo.MAG_ad_type_text') ,('dbo.MAG_page') ,('dbo.MAG_status_history') ,('dbo.MAGAD_DL_link') ,('dbo.MAGAD_technical_criteria') ,('dbo.Magazine') ,('dbo.Magazine_type') ,('dbo.Magazine_type_text') ,('dbo.Maintenance') ,('dbo.Maintenance_contract') ,('dbo.Manual_clocking') ,('dbo.Margin_class') ,('dbo.Margin_class_text') ,('dbo.Margin_factor_detail') ,('dbo.Margin_factor_master') ,('dbo.Margin_factor_master_text') ,('dbo.Marital_status') ,('dbo.Marketing_action_detail') ,('dbo.Marketing_activity_header') ,('dbo.Marketing_type_text') ,('dbo.Material_requirement_link') ,('dbo.MRP_log') ,('dbo.MSpeer_conflictdetectionconfigrequest') ,('dbo.MSpeer_conflictdetectionconfigresponse') ,('dbo.MSpeer_lsns') ,('dbo.MSpeer_originatorid_history') ,('dbo.MSpeer_request') ,('dbo.MSpeer_response') ,('dbo.MSpeer_topologyrequest') ,('dbo.MSpeer_topologyresponse') ,('dbo.MSpub_identity_range') ,('dbo.Occupation') ,('dbo.Occupation_text') ,('dbo.OFFCLD_reject') ,('dbo.Offline_clocking') ,('dbo.Offline_clocking_detail') ,('dbo.OPT_measure') ,('dbo.OPT_task_info') ,('dbo.OU_advertising_space') ,('dbo.OU_authorized_PD') ,('dbo.OU_group') ,('dbo.OU_group_link') ,('dbo.OU_group_text') ,('dbo.OU_item_link') ,('dbo.OU_store_type_budget') ,('dbo.OU_store_type_text') ,('dbo.OUAS_DL_link') ,('dbo.OUAS_technical_criteria') ,('dbo.Package_detail') ,('dbo.Package_doc_line_link') ,('dbo.Package_header') ,('dbo.Packing_list') ,('dbo.Packing_type') ,('dbo.Packing_type_text') ,('dbo.Payment_input_detail') ,('dbo.Payment_input_header') ,('dbo.Payment_proposal_bank') ,('dbo.Payment_proposal_batch') ,('dbo.Payroll_batch') ,('dbo.Payroll_batch_bank') ,('dbo.Payroll_batch_detail') ,('dbo.Payroll_calc_detail') ,('dbo.Payroll_calculation') ,('dbo.Payroll_employee_profile') ,('dbo.Payroll_heading') ,('dbo.Payroll_heading_specs') ,('dbo.Payroll_heading_text') ,('dbo.Payroll_parameters') ,('dbo.Payroll_period') ,('dbo.Payroll_period_master') ,('dbo.Payroll_period_master_text') ,('dbo.Payroll_period_text') ,('dbo.Payroll_period_type') ,('dbo.Payroll_period_type_text') ,('dbo.Payroll_profile_detail') ,('dbo.Payroll_profile_master') ,('dbo.Payroll_profile_master_text') ,('dbo.Payroll_scale_date') ,('dbo.Payroll_scale_detail') ,('dbo.Payroll_scale_master') ,('dbo.Payroll_scale_master_text') ,('dbo.PCA_EMC_absence') ,('dbo.PCA_EMC_loan') ,('dbo.PCA_payment_method') ,('dbo.PCC_totalizator_link') ,('dbo.PCT_totalizator_link') ,('dbo.PD_minimum_amount') ,('dbo.PD_pre_cost_entry_link') ,('dbo.PEM_amount_breakdown') ,('dbo.PerformancePoint') ,('dbo.PerformancePointAggregation') ,('dbo.Periodic_document_model') ,('dbo.PH_custom_insurance_plan') ,('dbo.PH_item_insurance_link') ,('dbo.PH_Prescriber_ins_link') ,('dbo.PH_std_posology_text') ,('dbo.PHID_alloy') ,('dbo.Phone_call_log') ,('dbo.PJ_item_link') ,('dbo.PJ_pre_cost_entry_link') ,('dbo.PJS_layout_detail') ,('dbo.PJS_layout_detail_text') ,('dbo.PJS_layout_master') ,('dbo.PJS_layout_master_text') ,('dbo.PJS_task_selection') ,('dbo.PJS_totalizator_link') ,('dbo.PKD_DL_link') ,('dbo.PPB_address_selection') ,('dbo.PPB_OU_selection') ,('dbo.PPB_payment_method') ,('dbo.PR_certificate_detail') ,('dbo.PR_certificate_header') ,('dbo.PR_certificate_layout') ,('dbo.PR_certificate_layout_text') ,('dbo.PR_cust_list_column') ,('dbo.PR_cust_list_column_text') ,('dbo.PR_customized_list') ,('dbo.PR_customized_list_text') ,('dbo.PR_global_value_link') ,('dbo.PR_global_value_link_text') ,('dbo.PR_official_list') ,('dbo.PR_official_list_col_text') ,('dbo.PR_official_list_column') ,('dbo.PR_official_list_text') ,('dbo.PR_periodicity_type') ,('dbo.PR_periodicity_type_text') ,('dbo.PRCH_EPP_link') ,('dbo.PRCH_status_history') ,('dbo.Pre_cost_entry') ,('dbo.Pre_entry_link') ,('dbo.Premise') ,('dbo.Premise_text') ,('dbo.Prescription') ,('dbo.Prescription_task_link') ,('dbo.PRH_activity_type_link') ,('dbo.PRH_boundary') ,('dbo.PRH_boundary_history') ,('dbo.PRH_boundary_text') ,('dbo.PRH_complement') ,('dbo.PRH_complement_text') ,('dbo.PRH_item_link') ,('dbo.PRH_layout_link') ,('dbo.PRH_list_column_link') ,('dbo.PRH_period_type') ,('dbo.PRH_PRHC_link') ,('dbo.PRH_totalizator_link') ,('dbo.Price_element') ,('dbo.Price_element_text') ,('dbo.Price_type_text') ,('dbo.Pro_svc_psbl_answer') ,('dbo.Pro_svc_psbl_answer_text') ,('dbo.Pro_svc_question') ,('dbo.Pro_svc_question_text') ,('dbo.Pro_svc_received_answer') ,('dbo.Pro_svc_session') ,('dbo.Pro_svc_session_answer') ,('dbo.Process_document') ,('dbo.Process_document_link') ,('dbo.Process_header') ,('dbo.Process_line') ,('dbo.Process_line_antecedence') ,('dbo.Process_line_option') ,('dbo.Process_option') ,('dbo.Process_overlap_header') ,('dbo.Process_overlap_line') ,('dbo.Process_overlap_text') ,('dbo.Process_revision') ,('dbo.Process_sub_contractor') ,('dbo.Production_time') ,('dbo.Project') ,('dbo.Project_address_link') ,('dbo.Project_criteria') ,('dbo.Project_entry') ,('dbo.Project_key') ,('dbo.Project_resource') ,('dbo.Project_status_history') ,('dbo.Project_structure') ,('dbo.Project_structure_text') ,('dbo.Project_weighting') ,('dbo.PROL_column_link') ,('dbo.Prospection') ,('dbo.Prospection_amount') ,('dbo.Prospection_criteria') ,('dbo.Prospection_reason') ,('dbo.PRPET_conversion') ,('dbo.Quantity_formula_detail') ,('dbo.Quantity_formula_master') ,('dbo.Quantity_formula_master_txt') ,('dbo.RAFAM_action_monitor') ,('dbo.RAFAM_notification') ,('dbo.REG_status_history') ,('dbo.Registration') ,('dbo.Registration_booth_link') ,('dbo.Religion') ,('dbo.Religion_text') ,('dbo.Reminder_method') ,('dbo.Repository_update_log') ,('dbo.Room_category') ,('dbo.Room_category_text') ,('dbo.Salary_grade') ,('dbo.Salary_grade_funct_link') ,('dbo.Salary_grade_history') ,('dbo.Salary_grade_text') ,('dbo.Sales_rep_address_list') ,('dbo.Sales_representative') ,('dbo.Sector') ,('dbo.Sector_text') ,('dbo.Security_custody') ,('dbo.Security_group') ,('dbo.Security_group_text') ,('dbo.Serial_number') ,('dbo.Serial_number_history') ,('dbo.Serial_number_status') ,('dbo.Serial_number_status_text') ,('dbo.Signature_schema') ,('dbo.Signature_schema_detail') ,('dbo.Signature_schema_text') ,('dbo.Signboard') ,('dbo.Signboard_contract') ,('dbo.Signboard_DL_link') ,('dbo.Signboard_location') ,('dbo.Signboard_location_hist') ,('dbo.Signboard_per_status_hist') ,('dbo.Signboard_periodicity') ,('dbo.Signboard_type') ,('dbo.Signboard_type_text') ,('dbo.SQL_connection') ,('dbo.Standard_cost_param') ,('dbo.Standard_cost_rate') ,('dbo.Standard_unit_conversion') ,('dbo.STASD_event') ,('dbo.Statistic') ,('dbo.Statistic_OU_link') ,('dbo.Status_schema') ,('dbo.Status_schema_detail') ,('dbo.Status_schema_header') ,('dbo.Status_schema_header_text') ,('dbo.Stock_trans_effective_cost') ,('dbo.Stock_trans_type') ,('dbo.Stock_trans_type_text') ,('dbo.STT_PD_link') ,('dbo.Sub_contractor_terms') ,('dbo.SUB_RAFAM_parameter') ,('dbo.Surplus_header') ,('dbo.Surplus_header_text') ,('dbo.Surplus_line') ,('dbo.Swiss_AVS_structure') ,('dbo.Swiss_customs_detail') ,('dbo.Swiss_EMCH_supplement') ,('dbo.Swiss_payroll_parameters') ,('dbo.Symptom') ,('dbo.Symptom_text') ,('dbo.sysarticleupdates') ,('dbo.sysdiagrams') ,('dbo.sysschemaarticles') ,('dbo.System_email') ,('dbo.System_site_link_auth') ,('dbo.System_site_SUB_link') ,('dbo.systranschemas') ,('dbo.Task') ,('dbo.Task_address_link') ,('dbo.Task_budget_detail') ,('dbo.Task_criteria') ,('dbo.Task_key') ,('dbo.Task_progress_history') ,('dbo.Task_resource') ,('dbo.Task_status_history') ,('dbo.TC_authorized_value') ,('dbo.Tech_criteria_value_text') ,('dbo.Technical_criteria_text') ,('dbo.Terms_schema_detail') ,('dbo.Terms_schema_header') ,('dbo.Terms_schema_header_text') ,('dbo.Time_period') ,('dbo.Time_period_master') ,('dbo.Time_period_master_text') ,('dbo.Time_period_text') ,('dbo.Time_sheet_rate') ,('dbo.Time_sheet_special_rate') ,('dbo.Time_table_schema') ,('dbo.Time_table_schema_date') ,('dbo.Time_table_schema_detail') ,('dbo.Time_table_schema_history') ,('dbo.Time_table_schema_text') ,('dbo.Time_table_type') ,('dbo.Time_table_type_detail') ,('dbo.Time_table_type_history') ,('dbo.Time_table_type_text') ,('dbo.TK_pre_cost_entry_link') ,('dbo.TT_AC_ACPE_lock') ,('dbo.TT_Account_Statement') ,('dbo.TT_ACS_dataset') ,('dbo.TT_Address_Extraction') ,('dbo.TT_Auto_Data_Acquisition') ,('dbo.TT_Change_tracking_history') ,('dbo.TT_CICR_LD_PCEM') ,('dbo.TT_Clocking_Key_Status') ,('dbo.TT_DH_auto_addr') ,('dbo.TT_DH_auto_document_line') ,('dbo.TT_DH_generation') ,('dbo.TT_DH_Manual_Stock_Allocation') ,('dbo.TT_DH_transitory') ,('dbo.TT_DL') ,('dbo.TT_DL_generation') ,('dbo.TT_DL_Part_List_Exchange') ,('dbo.TT_DL_planning') ,('dbo.TT_DWH_discount_voucher') ,('dbo.TT_DWH_price_modifier_extraction') ,('dbo.TT_DWH_sales_extraction') ,('dbo.TT_EMC') ,('dbo.TT_EMC_Security') ,('dbo.TT_EPP') ,('dbo.TT_EPP_Withholding_Tax') ,('dbo.TT_Export_S13') ,('dbo.TT_extraction_timestamp') ,('dbo.TT_File_Transfer') ,('dbo.TT_fixed_price_pricing') ,('dbo.TT_FUN_OUSH_link') ,('dbo.TT_GetNext_ID') ,('dbo.TT_IMP_bom_item') ,('dbo.TT_IMP_DL') ,('dbo.TT_IMP_DL_1') ,('dbo.TT_IMP_item') ,('dbo.TT_IMP_item_2') ,('dbo.TT_IMP_item_conso') ,('dbo.TT_IMP_item_cover_date') ,('dbo.TT_IMP_item_PL') ,('dbo.TT_IMP_item_PL_Tot') ,('dbo.TT_IMP_item_stock') ,('dbo.TT_IMP_Matr') ,('dbo.TT_IMP_wko') ,('dbo.TT_INB_generation') ,('dbo.TT_IT') ,('dbo.TT_IT_monthly_stat') ,('dbo.TT_ITCAT') ,('dbo.TT_ITCAT_OUST_link') ,('dbo.TT_ITDH_Send') ,('dbo.TT_item_availability_check') ,('dbo.TT_item_criteria') ,('dbo.TT_Item_Dispatch_Load') ,('dbo.TT_Item_Fixed_Price') ,('dbo.TT_Item_large_generic_sequence') ,('dbo.TT_Item_Popup_Text') ,('dbo.TT_Item_Popup_Text_Overlap') ,('dbo.TT_Item_Relation_Info') ,('dbo.TT_Item_seasonal_stock_info') ,('dbo.TT_Item_Status') ,('dbo.TT_ITQ_Export') ,('dbo.TT_ITSA_product_line') ,('dbo.TT_ITSH_generation') ,('dbo.TT_LD_budget') ,('dbo.TT_LD_DH_FINA') ,('dbo.TT_LD_Doc_Line') ,('dbo.TT_LD_EMC_Payroll_Var') ,('dbo.TT_LD_EMC_periodicity') ,('dbo.TT_LD_Entry') ,('dbo.TT_LD_Fixed_Price') ,('dbo.TT_LD_Fixed_Price_Factor') ,('dbo.TT_LD_generic_item') ,('dbo.TT_LD_IT_Category_management') ,('dbo.TT_LD_Item_Visilab') ,('dbo.TT_LD_PR_Employee_Profile') ,('dbo.TT_LORE_item_facing') ,('dbo.TT_LORE_Label_Printing') ,('dbo.TT_LORE_wilson_correction_factor') ,('dbo.TT_OU_advertising_move') ,('dbo.TT_OU_advertising_process') ,('dbo.TT_OU_Price_Code_Priority') ,('dbo.TT_OU_store_history') ,('dbo.TT_Payroll_Stat') ,('dbo.TT_PCA') ,('dbo.TT_PH_ITQ_Import') ,('dbo.TT_PH_purchase_condition') ,('dbo.TT_PH_purchase_dashboard') ,('dbo.TT_PH_purchase_order_error') ,('dbo.TT_PH_Purchase_Physician') ,('dbo.TT_PH_purchase_price') ,('dbo.TT_PH_RG_Label_Print') ,('dbo.TT_PHFCM_extraction') ,('dbo.TT_PHGD_Exp_AC') ,('dbo.TT_PHGD_Exp_ACBARCODE') ,('dbo.TT_PHGD_Exp_ACNAM') ,('dbo.TT_PHGD_Exp_NETART_ACTION') ,('dbo.TT_PHGD_Exp_NETART_GREEN') ,('dbo.TT_PHGD_Exp_WHSPRICE') ,('dbo.TT_PHGD_Fixed_Price') ,('dbo.TT_Physical_Inventory_Detail_Load') ,('dbo.TT_PIH_Source_FNRA_Update') ,('dbo.TT_PRCH') ,('dbo.TT_Pre_Calc') ,('dbo.TT_Search_Address') ,('dbo.TT_Search_DH') ,('dbo.TT_Search_DH_Total') ,('dbo.TT_Search_HR_Header') ,('dbo.TT_Search_Item') ,('dbo.TT_Serial_Number') ,('dbo.TT_signboard_contract_invoicing') ,('dbo.TT_SN_DH_WKO') ,('dbo.TT_STM') ,('dbo.TT_SUN_Web_Item') ,('dbo.TT_Synchro') ,('dbo.TT_Synchro_Account_List') ,('dbo.TT_Synchro_Item_List') ,('dbo.TT_Tax_List_Recap') ,('dbo.TT_TXT_DL') ,('dbo.TT_User_Badge_Identifier') ,('dbo.TT_Visilab_AD_AMR_regular_import') ,('dbo.TT_Visilab_address_data_regular_import') ,('dbo.TT_Visilab_IT_AMR_regular_import') ,('dbo.TT_Visilab_item_data_regular_import') ,('dbo.TT_VMI') ,('dbo.TT_Web_Item') ,('dbo.TT_WKO') ,('dbo.TT_WKOP') ,('dbo.TT_XML_goods_receiving') ,('dbo.TTSNH_authorized_status') ,('dbo.User_card') ,('dbo.Variable_price') ,('dbo.VAT_period') ,('dbo.VAT_period_text') ,('dbo.Vehicle') ,('dbo.Vehicle_text') ,('dbo.Vendor_managed_inv_text') ,('dbo.Vendor_managed_inventory') ,('dbo.VIP_card') ,('dbo.VIP_card_issue_type') ,('dbo.VIP_card_type_link') ,('dbo.VIP_card_type_text') ,('dbo.VIP_deny_discount') ,('dbo.VIPCT_marketing_type') ,('dbo.Weekly_schema_detail') ,('dbo.Weekly_schema_header') ,('dbo.WKOP_assignment') ,('dbo.WKOP_external_reference') ,('dbo.WKOP_planning') ,('dbo.WKOP_planning_header') ,('dbo.WKPA_capacity') ,('dbo.Work_center') ,('dbo.Work_center_text') ,('dbo.Work_location') ,('dbo.Work_location_text') ,('dbo.Work_order') ,('dbo.Work_order_BOM_location') ,('dbo.Work_order_cost') ,('dbo.Work_order_process') ,('dbo.Work_order_process_qty') ,('dbo.Work_order_status_history') ,('dbo.Work_permit') ,('dbo.Work_sheet_header') ,('dbo.Work_type') ,('dbo.Work_type_text') ,('dbo.Workplace') ,('dbo.Workplace_text') ,('dbo.ZIP_distance_chart') ,('del.CCI_address') ,('del.CCI_address_key') ,('del.CCI_ATA') ,('del.CCI_document_header') ,('del.CCI_item') ,('del.CCI_PD_deposit_code') ,('del.CCI_reminder') ,('del.OPT_DH_info') ,('del.TT_LD_CCI_ATA_online') ,('upd.Change_tracking_monitor') ,('wkl.PolLinkLog') ,('wkl.ServiceBrokerError') ,('wkl.TriggerEvent') )y(tableName) SELECT [s].[fqdn], s.schem, s.tbl, CASE WHEN u.[fqdn] IS not NULL THEN 1 ELSE 0 END AS isUsed FROM @toAnswer s LEFT JOIN @usedTables u ON u.[fqdn] = s.[fqdn] --WHERE s.schem = 'dbo' ORDER BY [isUsed], s.schem, s.tbl