USE [Arizona] SET XACT_ABORT ON; SET NOCOUNT ON; GO BEGIN TRANSACTION --#region variables DECLARE @col VARCHAR(500)=''; DECLARE @cols_to_add_other_guid TABLE( schema_name VARCHAR(100), table_name VARCHAR(200), column_name VARCHAR(200), command NVARCHAR(MAX) ) DECLARE @unused TABLE ( schemaName VARCHAR(10), tblName VARCHAR(200) ); DECLARE @cols_to_add_other TABLE( schema_name VARCHAR(100), table_name VARCHAR(200), column_name VARCHAR(200), command NVARCHAR(MAX) ) DECLARE @schemaName VARCHAR(100), @tblName VARCHAR(200); DECLARE @cnt BIGINT; DECLARE @q NVARCHAR(MAX)=''; DECLARE @cmd NVARCHAR(4000)=''; --#endregion --#region move classification not in the Galenica type to ==> other - general DECLARE crs_not_galenica CURSOR FAST_FORWARD READ_ONLY FOR SELECT schema_name(o.[schema_id])+'.'+o.[name]+'.'+c.[name] AS col FROM sys.sensitivity_classifications sc JOIN sys.objects O ON sc.major_id = O.object_id JOIN sys.columns C ON sc.major_id = C.object_id AND sc.minor_id = C.column_id WHERE CAST(sc.[information_type] AS VARCHAR(500)) <> 'Galenica Used Personal Informations' OPEN crs_not_galenica FETCH NEXT FROM crs_not_galenica INTO @col WHILE @@FETCH_STATUS = 0 BEGIN --PRINT 'ADD SENSITIVITY CLASSIFICATION TO '+@col+' WITH (LABEL=''General'', INFORMATION_TYPE=''Other'', RANK=Low ) '; EXEC('ADD SENSITIVITY CLASSIFICATION TO '+@col+' WITH (LABEL=''General'', INFORMATION_TYPE=''Other'', RANK=Low ) '); FETCH NEXT FROM crs_not_galenica INTO @col END CLOSE crs_not_galenica DEALLOCATE crs_not_galenica --#endregion --#region fetch row count in every tables IF OBJECT_ID('tempdb..#tblToExclude')IS NOT NULL BEGIN; DROP TABLE #tblToExclude; END; CREATE TABLE #tblToExclude ( schemaName VARCHAR(50), tableName VARCHAR(200), rowsCnt bigint ,toExclude BIT DEFAULT 0 ,toSetOther BIT DEFAULT 0 ,reasonToExclude VARCHAR(MAX) ); INSERT INTO #tblToExclude ([schemaName], [tableName], [rowsCnt]) SELECT [TABLE_SCHEMA], [TABLE_NAME], NULL FROM [INFORMATION_SCHEMA].[TABLES] WHERE [TABLE_TYPE] ='BASE TABLE' ; DECLARE crs_countRows CURSOR FAST_FORWARD READ_ONLY FOR SELECT [schemaName], [tableName] FROM #tblToExclude WHERE [rowsCnt] IS NULL OPEN crs_countRows FETCH NEXT FROM crs_countRows INTO @schemaName, @tblName WHILE @@FETCH_STATUS = 0 BEGIN --PRINT CONVERT(VARCHAR(20), CURRENT_TIMESTAMP, 114)+' - Counting rows in '+@schemaName+'.'+@tblName; SET @q = ' declare @cnt bigint; select @cnt = count(1) from '+@schemaName+'.'+@tblName+'; update #tblToExclude set [rowsCnt] = @cnt where [schemaName]='''+@schemaName+''' and [tableName] = '''+@tblName+''' ' EXEC (@q) FETCH NEXT FROM crs_countRows INTO @schemaName, @tblName END CLOSE crs_countRows DEALLOCATE crs_countRows --#endregion --#region Set every tables with 0 records to be excluded from active classification UPDATE [#tblToExclude] SET [toExclude] = 1, [reasonToExclude] = 'no rows in table' WHERE [rowsCnt] = 0 ; PRINT CONVERT(VARCHAR(20), CURRENT_TIMESTAMP, 114)+' - excluded because no data in table. '+REPLACE(REPLACE(CONVERT(VARCHAR(100), CONVERT(MONEY, @@rowcount), 1),',',''''),'.00','')+' row(s) affected.'; --#endregion --#region exclude fixed temp tables --UPDATE tt --SET [toExclude] = 1, [reasonToExclude] = 'Fixed temp table' --FROM [#tblToExclude] tt --WHERE tt.[tableName] LIKE 'TT%' --; --PRINT CONVERT(VARCHAR(20), CURRENT_TIMESTAMP, 114)+' - excluded fixed temp table. '+REPLACE(REPLACE(CONVERT(VARCHAR(100), CONVERT(MONEY, @@rowcount), 1),',',''''),'.00','')+' row(s) affected.'; --#endregion --#region Set tables known to be not used anymore to be excluded from active classification INSERT INTO @unused ([schemaName], [tblName]) SELECT [schemaName], [tblName] FROM ( VALUES ('dbo','TT_File_Transfer') , ('dbo','pfs_gdi$') , ('dbo','BOM_revision') , ('dbo','fixed_price_Pmed_bkp') , ('dbo','Project_weighting') , ('dbo','TT_Visilab_AD_AMR_regular_import') , ('dbo','ATS_time_period_balance') , ('dbo','EMCH_payroll_period_link') , ('dbo','TT_LD_EMC_Payroll_Var') , ('dbo','TT_Visilab_address_data_regular_import') , ('dbo','WKPA_capacity') , ('dbo','Clocking_summary') , ('dbo','APS_version_hist_detail') , ('dbo','TT_Synchro_Account_List') , ('dbo','EAS_APS_operation_link') , ('dbo','EMC_absence') , ('dbo','TT_Payroll_Stat') , ('dbo','Manual_clocking') , ('dbo','TT_Visilab_IT_AMR_regular_import') , ('dbo','Activity_supplement') , ('dbo','ZDBA_localisation') , ('dbo','Clocking') , ('dbo','TT_Visilab_item_data_regular_import') , ('dbo','TT_Galenicare_Bonart') , ('dbo','Process_revision') , ('dbo','PCA_EMC_absence') , ('dbo','TT_Search_Item') , ('dbo','TT_Pre_Calc') , ('wkl','ArizonaToWKLDataTransformationLog') , ('dbo','Sheet1$') , ('dbo','EMC_termination_type') , ('dbo','Family_allowance') , ('dbo','TT_EPP_Withholding_Tax') , ('dbo','EMC_termination_reason') , ('dbo','TT_GetNext_ID') , ('dbo','TT_LORE_item_facing') , ('dbo','Interco_synchronization') , ('dbo','TT_Tax_List_Recap') , ('dbo','Quantity_formula_detail') , ('dbo','TT_VMI') , ('dbo','Payroll_batch_bank') , ('dbo','TT_LD_generic_item') , ('dbo','Occupation') , ('dbo','Pro_svc_received_answer') , ('dbo','TT_DL_planning') , ('dbo','Asset_insurance') , ('dbo','TT_Visilab_ADG_AMR_regular_import') , ('dbo','Payroll_batch_detail') , ('dbo','TT_PH_RG_Label_Print') , ('dbo','Asset_leasing') , ('dbo','TT_Visilab_data_regular_import') , ('dbo','EAS_structure_operation') , ('dbo','Time_table_schema_history') , ('dbo','TT_PH_purchase_order_error') , ('dbo','PDX_mapping_wholesaler') , ('dbo','Event_premise') , ('dbo','TT_DH_Manual_Stock_Allocation') , ('dbo','TT_Clocking_Key_Status') , ('dbo','Asset_maintenance') , ('dbo','TT_STM') , ('dbo','Symptom') , ('dbo','External_entry') , ('dbo','PRH_list_column_link') , ('dbo','TTSNH_authorized_status') , ('dbo','TT_User_Badge_Identifier') , ('dbo','ATT_time_period_balance') , ('dbo','EAS_structure_trigger') , ('dbo','TT_SN_DH_WKO') , ('dbo','TT_GAL_Price_Factor') , ('dbo','Contract_daily_time') , ('dbo','TT_LD_Doc_Line') , ('dbo','TT_DL_Part_List_Exchange') , ('dbo','HR_certificate') , ('dbo','TT_Synchro') , ('dbo','TT_WKOP') , ('dbo','TT_BRE_Plan_Fab_Index') , ('dbo','TT_IMP_bom_item') , ('dbo','Time_table_type_history') , ('dbo','Contract_time_adjustment') , ('dbo','TT_LD_EMC_periodicity') , ('dbo','TT_IMP_item') , ('dbo','Time_table_type_detail') , ('dbo','Facility_technical_criteria') , ('dbo','TT_LD_PR_Employee_Profile') , ('dbo','TT_IMP_item_2') , ('dbo','TT_IMP_item_stock') , ('dbo','PR_certificate_header') , ('dbo','TT_PRCH') , ('dbo','TT_IMP_item_cover_date') , ('dbo','TT_LD_IT_Category_management') , ('dbo','TT_IMP_item_conso') , ('dbo','PRH_activity_type_link') , ('dbo','Payroll_scale_date') , ('dbo','TT_OU_Price_Code_Priority') , ('dbo','TT_IMP_item_PL') , ('dbo','OFFCLD_reject') , ('dbo','TT_LD_DH_FINA') , ('dbo','TT_IMP_item_PL_Tot') , ('upd','Change_tracking_monitor') , ('dbo','TT_PH_APOS_item_status') , ('dbo','Payroll_calc_detail') , ('dbo','TT_DH_auto_addr') , ('dbo','TT_IMP_wko') , ('dbo','FA_RAFAM_type') , ('dbo','Alloy_element_quantity') , ('dbo','Arrondis$') , ('dbo','Alloy_element') , ('dbo','TT_IMP_DL') , ('dbo','Prescription_task_link') , ('dbo','WKOP_planning_header') , ('dbo','TT_DH_auto_document_line') , ('dbo','Alloy_detail') , ('dbo','TT_IMP_DL_1') , ('dbo','TT_PHGD_Fixed_Price') , ('dbo','TT_IMP_Matr') , ('dbo','PRH_layout_link') , ('dbo','TT_PHGD_Exp_AC') , ('dbo','PerformancePoint') , ('dbo','Offline_clocking') , ('dbo','PerformancePointAggregation') , ('dbo','TT_PHGD_Exp_ACBARCODE') , ('dbo','ATT_cust_list_column') , ('dbo','HR_training_field') , ('dbo','TT_BCR_WKO') , ('dbo','Weekly_schema_detail') , ('dbo','PRH_period_type') , ('dbo','sysdiagrams') , ('dbo','TT_PHGD_Exp_ACNAM') , ('dbo','TT_Auto_Data_Acquisition') , ('dbo','PRH_totalizator_link') , ('dbo','RAFAM_action_monitor') , ('dbo','Knowledge_category') , ('dbo','ATT_list_column_link') , ('dbo','Knowledge_base_category') , ('dbo','TT_BCR_RECAP_T2') , ('wkl','ServiceBrokerError') , ('dbo','TT_PHGD_Exp_NETART_ACTION') , ('dbo','HR_training_type') , ('dbo','TT_LD_budget') , ('dbo','TT_Export_WHSPRICE') , ('dbo','PJS_totalizator_link') , ('dbo','Knowledge_base_key') , ('dbo','PR_cust_list_column') , ('dbo','TT_PHGD_Exp_NETART_GREEN') , ('dbo','Bmc_license') , ('del','PH_qualification') , ('dbo','TT_PHGD_Exp_WHSPRICE') , ('dbo','BMH_rule_type_link') , ('dbo','TT_Ctrl_Item_PH') , ('dbo','TT_LD_Fixed_Price_Factor') , ('dbo','PCA_EMC_loan') , ('dbo','TT_Export_NETART_GREEN') , ('dbo','Process_document') , ('dbo','EFT_OW_rule') , ('dam','MonitorTableHash') , ('dbo','BOM_rule') , ('dbo','TT_Export_NETART_ACTION') , ('dbo','ACS_totalizator_link') , ('dbo','BML_rule_link') , ('dbo','TT_Export_ACNAM') , ('dbo','PR_global_value_link') , ('dam','HashValueUniqueIndexInt') , ('dbo','CCI_address_key') , ('dbo','Contract_time_table_header') , ('dbo','TT_DWH_sales_extraction') , ('dbo','Custom_export_licence') , ('dbo','BMOH_selected_rule') , ('dbo','dtproperties') , ('dbo','TT_SUN_Web_Item') , ('dam','HashValueUniqueIndexGuid') , ('dbo','TT_LD_Item_Visilab') , ('dbo','TT_DWH_price_modifier_extraction') , ('dbo','Payroll_period_type') , ('dbo','TT_AC_ACPE_lock') , ('dbo','Bmc_system') , ('dbo','Process_document_link') , ('dbo','TT_ITQ_Export') , ('dbo','TT_Export_AC') , ('dbo','Surplus_line') , ('dbo','Process_line_antecedence') , ('dbo','Project_resource') , ('dbo','TT_PH_ITQ_Import') , ('dbo','PRCH_EPP_link') , ('dbo','TT_INB_generation') , ('dbo','systranschemas') , ('dbo','Process_line_option') , ('dbo','PJS_layout_detail') , ('dbo','TT_OU_advertising_process') , ('dbo','TT_LD_CCI_ATA_online') , ('dbo','Process_overlap_line') , ('dbo','Clocking_message') , ('dbo','TT_DH_transitory') , ('dbo','GaldatItemsWithStatus') , ('dbo','CLK_user_interface') , ('dbo','BMOH_formula_variable') , ('dbo','PJS_task_selection') , ('dbo','TT_Web_Item') , ('dbo','TT_Ctrl_Item') , ('dbo','Item_alloy_quantity') , ('dbo','CLT_authorized_CLKG') , ('dbo','Machine_downtime') , ('dbo','Element_transaction') , ('dbo','Task_resource') , ('dbo','EMC_certificate_layout') , ('dbo','AUTO_to_round$') , ('dbo','TT_CICR_LD_PCEM') , ('dbo','BOM_location') , ('dbo','Payroll_period') , ('dbo','Clocking_terminal_profile') , ('dbo','TT_ITSH_generation') , ('dbo','TT_PHFCM_extraction') , ('dbo','PRH_PRHC_link') , ('dbo','Offline_clocking_detail') , ('dbo','CLTP_schedule') , ('dbo','TT_IT') , ('dbo','HR_skill_level') , ('dbo','AX_item_mappings_rules') , ('dbo','CLTP_user_interface') , ('dbo','PHGD_MCMTXT_TEMP') , ('dbo','TT_ITCAT') , ('dbo','TT_FUN_OUSH_link') , ('dbo','Task_budget_detail') , ('dbo','Asset_investment_history') , ('dbo','HR_skill_type') , ('dbo','TT_OU_store_history') , ('dbo','Salary_grade_funct_link') , ('dbo','WKOP_planning') , ('dbo','Process_overlap_header') , ('dbo','Event_sector') , ('dbo','zz_tr_01') , ('dbo','TT_address_exp') , ('dbo','document_line_link_pda') , ('dbo','TT_address_exp_ESC') , ('dbo','TT_address_double') , ('dbo','TT_PMP') , ('dbo','Wprice_item') , ('dbo','TT_item_PV') , ('dbo','TriaFact_AutoCorrect') , ('dbo','TT_fobl_lines') , ('dbo','PHGD_FCMTXT_lpe') , ('dbo','PHGD_MCMTXT_lpe') , ('dbo','TT_item_availability_check_mouchard') , ('dbo','patient_card_fid$') , ('dbo','temp_mouchard_stm') , ('dbo','T_STM_Create') , ('dbo','TT_Change_tracking_history') , ('dbo','TT_change_tracking_triggers') , ('del','Address_merge_prevalidation') , ('del','PDX_mapping_wholesaler') , ('dbo','Bmc_application_default_backup_vesta') , ('dbo','ITCAT_IT_link_09_09_2015') , ('dbo','Config_Sync_V') , ('dbo','TT_PPUB_itk_src') , ('dbo','preissenkung') , ('dbo','tt_compteur') , ('dbo','DBA_Label_Monitoring') , ('dbo','DBA_Servers_Site') , ('dbo','LORE_supplying_procedure_savGBA') , ('dbo','brand$') , ('dbo','brand_line$') , ('dbo','TT_PPUB_itk') , ('dbo','brl_phcode$') , ('dbo','TT_xPUB_itk') , ('dbo','tt_GBA_list') , ('dbo','TT_Criteria') , ('dbo','DBA_Job_Monitoring') , ('dbo','TT_item_II') , ('dbo','DBA_Job_List') , ('dbo','TT_item_type_2') , ('dbo','TT_item_type_3') , ('dbo','TT_item_type_5') , ('dbo','TT_item_type_6') , ('dbo','Item_LORE_min_max_614') , ('dbo','Bichsel') , ('dbo','TT_Item_20171005') , ('dbo','xpub_to_upload') , ('dbo','TT_OU_price_code_priority_20171026') , ('dbo','RAFAM_notification_error') , ('dbo','aps_monitor_table_SUN_SPE') , ('dbo','TT_GBA_Supplier') , ('dbo','aps_monitor_table_SUN_SPE2') , ('dbo','temp_PHGD_ACCHAIN') , ('dbo','TT_address') , ('dbo','S13X_NUS') , ('dbo','TT_itsh') , ('dbo','sales_tax_code_sav') , ('dbo','tt_err_sync_dve') , ('dbo','sales_tax_rate_sav') , ('dbo','SAV_bmc_user_role') , ('dbo','TT_maj_default_supplier') , ('dbo','TT_item') , ('dbo','TT_Fusion_Item_relation_info') , ('dbo','SUN_DBA_LOGS') , ('dbo','LD_external_item') , ('dbo','item_link_del') , ('dbo','KuKo038') , ('dbo','LORE_item_facing_20160302') , ('dbo','tt_table') , ('dbo','MinMax_Facings_Output$') , ('dbo','vip_card_20040831') , ('dbo','TT_records') , ('dbo','Account_link_secu_doublon') , ('dbo','Account_chart_secu_doublon') , ('dbo','Account_secu_doublon') , ('dbo','Account_key_secu_doublon') , ('dbo','Account_text_secu_doublon') , ('dbo','Account_chart_secu_doublons_SPE') , ('dbo','TT_Upd_Account') , ('dbo','item_quantity_sav_20170405') , ('dbo','Account_chart_secu_doublons') , ('dbo','date_peremption$') , ('dbo','Address_group_text_Merge') , ('dbo','Bmc_user_role_2016_04_04') , ('dbo','TT_fusion_Item_status_history_II') , ('dbo','TT_Sync_Autoprod_AZ') , ('dam','ChecksumUniqueIndex_Work_type_text') , ('dbo','LD_item_FP') , ('dbo','Entry_Debug') , ('dbo','TT_excepted_field') , ('dbo','LORE_item_Facing20160308') , ('dbo','tt_ld_entry_dpa') , ('dbo','t_adk') , ('dbo','FUN_OUSH_link_patrice') , ('dbo','tt_ld_entry_dpa_2') , ('dbo','Entry_Sans_DH') , ('dbo','TT_PHGD_AC_Ins_Code') , ('dbo','TT_Rayons_textes') , ('dbo','TT_OU_advertising_process_dca') , ('dbo','OU_store_type_2016_05_12') , ('dbo','OU_store_type_text_2016_05_12') , ('dbo','ACS_totalizator_link_dve') , ('dbo','TT_XPUB_itk') , ('dbo','tt_gal_price_factor') , ('dbo','pda_CRM_reprocessing') , ('dbo','TT_Address') , ('dbo','Item_LORE_min_max_complet') , ('dbo','TT_Fusion_Item') , ('dbo','ZZ_DVE_SYNC') , ('dbo','Item_catalog_text_2016_11_09') , ('dbo','TT_fusion_Address') , ('dbo','ITCAT_IT_link_2016_11_09') , ('dbo','TT_Fusion_Item_text') , ('dbo','TT_Fusion_Item_sale') , ('dbo','TT_Fusion_PH_Item') , ('dbo','TT_fusion_telecom') , ('dbo','TT_ITSH') , ('dbo','TT_Fusion_Item_Status_History') , ('dbo','TT_LORE_item_facing_20150609') , ('dbo','TT_SUN_sp_exported') , ('dbo','LORE_service_level_rate_2016_08_19') , ('dbo','z_dve_pharmacode') , ('dbo','OU_store_history_2016_08_22') , ('dbo','DPA_tax_list') , ('dbo','DPA_dh_tax') , ('dbo','Item_statistics_yearly_OLD') , ('dbo','TT_fusion_item_relation_info') , ('dbo','APS_monitor_row_OLD') , ('dbo','APS_monitor_row_OLD2') , ('dbo','Item_statistics_monthly_new') , ('dbo','Item_statistics_yearly_new') , ('dbo','ph_item_20040325') , ('dbo','t_ol') , ('dbo','t_ol2') , ('dbo','zz_dve_duree') , ('dbo','MSmerge_tombstone') , ('dbo','MSmerge_contents') , ('dbo','MSmerge_genhistory') , ('dbo','MSmerge_settingshistory') , ('dbo','sysmergeschemachange') , ('dbo','sysmergesubsetfilters') , ('dbo','MSdynamicsnapshotjobs') , ('dbo','MSmerge_altsyncpartners') , ('dbo','MSmerge_partition_groups') , ('dbo','MSmerge_generation_partition_mappings') , ('dbo','MSmerge_current_partition_mappings') , ('dbo','MSmerge_past_partition_mappings') , ('dbo','MSmerge_dynamic_snapshots') , ('dbo','MSmerge_supportability_settings') , ('dbo','MSmerge_sessions') , ('dbo','MSmerge_log_files') , ('dbo','MSmerge_articlehistory') , ('dbo','MSrepl_errors') , ('dbo','MSmerge_history') , ('dbo','MSmerge_agent_parameters') , ('dbo','MSmerge_conflicts_info') , ('dbo','MSmerge_metadataaction_request') , ('dbo','MSmerge_errorlineage') , ('dbo','tmpOrdonnance') , ('dbo','MSmerge_identity_range') , ('dbo','sysmergepartitioninfo') , ('vesta','VestaVersion') , ('del','PHGD_WHS') , ('del','PHGD_WHSPRICE') , ('del','PHGD_AC') , ('del','PHGD_ACACT') , ('del','PHGD_ACBARCODE') , ('del','PHGD_ACCHAIN') , ('del','PHGD_ACCOMP') , ('del','PHGD_ACLIM') , ('del','PHGD_ACNAM') , ('del','PHGD_ACPRICEALG') , ('del','PHGD_ACMED') , ('del','Numerary_value') , ('del','PHGD_ACWHS') , ('del','Numerary_value_text') , ('del','PHGD_COMP') , ('dbo','ZZ_DVE_Item_calc_besoin') , ('dbo','TT_MESA_narcotic_export') , ('dbo','Item_LORE_min_max_test') , ('dbo','pda_duration_1500_3000') , ('dbo','ZZPDA_Rebuild_DLL') , ('dbo','tt_auto_data_acquisition_dpa') , ('dbo','Applications') , ('dbo','Settings') , ('dbo','Bmc_desktop_property_save') , ('dbo','ZZ_DVE_Item_calc_besoin_2') , ('dbo','ZZ_DVE_ITSSI') , ('dbo','BMC_trace') , ('dbo','BMC_Trace_dpa_item') , ('dbo','BMC_Trace_item_2') , ('dbo','TRACE_20120307_LPO') , ('dbo','ZZ_APS_monitor_row_OLD_SPE') , ('dbo','addres_link_201800807') , ('dbo','ph_prescriber_sav_20191203') , ('dbo','ph_physician_sav_20191203') , ('dbo','bkp_Item_inventory_20191210_AMA') , ('dbo','Bmc_application_default_backup_vesta_migration_lot3') , ('dbo','TT_Bmc_application_default_backup_vesta_migration_lot3') , ('dbo','Point_of_sale') /* technical data */ , ('dbo','Swiss_bank_clearing') /* technical data */ , ('dbo','System_site') /* technical data */ , ('dbo','Clocking_terminal') /* technical data */ , ('dbo','EAS_file_line') /* technical data */ , ('dbo','Email_pattern') /* technical data */ , ('dbo','EMC_payroll_period') /* technical data */ , ('dbo','Employee') /* technical data */ , ('dbo','Ems_room') /* technical data */ , ('dbo','Family_allowance') /* technical data */ , ('dbo','Phone_call_log') /* technical data */ , ('dbo','Swiss_AVS_structure') /* technical data */ , ('dbo','System_email') /* technical data */ , ('dbo','VIPCT_marketing_type') /* technical data */ , ('dbo','StarcardValidity') /* technical data */ , ('dbo','Bmc_user_profile') /* technical data */ , ('dbo','country') /* technical data */ , ('dbo','Document_line') /* technical data */ , ('dbo','Document_transfer_method') /* technical data */ , ('dbo','Organizational_unit') /* technical data */ , ('dbo','OU_manager') /* technical data */ , ('dbo','Payment_input_header') /* technical data */ , ('dbo','PH_insurance') /* technical data */ , ('dbo','PH_item') /* technical data */ , ('dbo','Point_of_sale') /* technical data */ , ('dbo','System_site') /* technical data */ , ('dbo','Booth') /* technical data */ , ('dbo','Clocking_terminal') /* technical data */ , ('dbo','country') /* technical data */ , ('dbo','Email_pattern') /* technical data */ , ('dbo','EMC_payroll_period') /* technical data */ , ('dbo','Employee') /* technical data */ , ('dbo','Ems_room') /* technical data */ , ('dbo','Family_allowance') /* technical data */ , ('dbo','Phone_call_log') /* technical data */ , ('dbo','Prospection') /* technical data */ , ('dbo','Swiss_AVS_structure') /* technical data */ , ('dbo','System_email') /* technical data */ , ('dbo','country') /* technical data */ )x (schemaName, tblName) /* set to "other" all columns of tables known to be ignored */ IF OBJECT_ID('tempdb..#tables_to_ignore')IS NOT NULL BEGIN; DROP TABLE #tables_to_ignore; END; CREATE TABLE #tables_to_ignore( [TABLE_SCHEMA] nvarchar(255), [TABLE_NAME] nvarchar(255), [Other] nvarchar(5), [Comment] nvarchar(255), [command] NVARCHAR(4000) ); INSERT INTO [#tables_to_ignore] ([TABLE_SCHEMA], [TABLE_NAME], [Other], [Comment], [command]) SELECT t.[TABLE_SCHEMA], t.[TABLE_NAME], t.[Other], t.[Comment], NULL FROM ( SELECT N'AP' AS [TABLE_SCHEMA], N'CustomerReminder' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'AP' AS [TABLE_SCHEMA], N'GlobalBlueRefund' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'AP' AS [TABLE_SCHEMA], N'InventoryScan' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'AP' AS [TABLE_SCHEMA], N'PrescriptionBookDetail' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'AP' AS [TABLE_SCHEMA], N'PrescriptionBookHeader' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'AP' AS [TABLE_SCHEMA], N'RepetitionReminder' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'AP' AS [TABLE_SCHEMA], N'SaleLoyalty' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'AP' AS [TABLE_SCHEMA], N'SaleWallet' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'AP' AS [TABLE_SCHEMA], N'ScannedDocument' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'AP' AS [TABLE_SCHEMA], N'StarcardValidity' AS [TABLE_NAME], NULL AS [Other], NULL AS [Comment] UNION ALL SELECT N'AP' AS [TABLE_SCHEMA], N'WebShopStatusQueue' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'atl' AS [TABLE_SCHEMA], N'Change_tracking_history' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'atl' AS [TABLE_SCHEMA], N'SQL_error_log' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'crs' AS [TABLE_SCHEMA], N'ProcessMessageLog' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dam' AS [TABLE_SCHEMA], N'AMR_count_config' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dam' AS [TABLE_SCHEMA], N'HashValueUniqueIndexGuid' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dam' AS [TABLE_SCHEMA], N'HashValueUniqueIndexInt' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dam' AS [TABLE_SCHEMA], N'MissingData' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dam' AS [TABLE_SCHEMA], N'MonitorTableHash' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'AC_profit_cost_type_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Acc_pre_cost_entry_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Acc_structure_master_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Account' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Account_ACPE_lock' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Account_balance' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Account_chart' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Account_credit_insurance' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Account_group' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Account_group_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Account_interest' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Account_interest_rate' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Account_interest_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Account_key' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Account_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Account_PD_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Account_structure' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Account_structure_master' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Account_structure_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Account_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Accounting_balance' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Accounting_balance_detail' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Accounting_period' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Accounting_plan' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Accounting_plan_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Accounting_turnover_agg' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'ACG_pre_cost_entry_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'ACG_profit_cost_type_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'ACPE_weighting_detail' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'ACPE_weighting_master' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'ACPE_weighting_master_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'ACS_account_list' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'ACS_layout_detail' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'ACS_layout_detail_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'ACS_layout_master' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'ACS_layout_master_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'ACS_profit_cost_type_list' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'ACS_totalizator_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Active_directory_user' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Activity' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Activity_prod_rate_default' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Activity_supplement' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Activity_supplement_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Activity_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Activity_type' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Activity_type_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Address' AS [TABLE_NAME], NULL AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Address_category' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Address_category_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Address_contact_person_list' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Address_criteria' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Address_distance_chart' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Address_group' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Address_group_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Address_invitation' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Address_invoicing_block' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Address_item_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Address_key' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Address_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Address_merge_prevalidation' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Address_monitor' AS [TABLE_NAME], NULL AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Address_remark' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Address_salutation' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Address_type' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Address_type_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Advert_support' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Advert_support_target' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Advert_support_type' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Advert_support_type_OU_cap' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Advert_support_type_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'AGD_DL_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Agenda' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Alloy_detail' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Alloy_element' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Alloy_element_quantity' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Alloy_element_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Alloy_header' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Alloy_header_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Alloy_pre_transaction' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Alloy_pre_transaction_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Alloy_pre_transaction_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Alloy_processing_cost' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Alloy_transaction' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Application_default' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'APS_connection_info' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'APS_context_monitor' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'APS_context_monitor_log' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'APS_monitor_row' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'APS_monitor_table' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'APS_synchro_journal' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'APS_tech_criteria_type' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'APS_tech_criteria_type_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'APS_version_hist_detail' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'APS_version_history' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Arrondis$' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'ASDP_detail' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Asset' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Asset_deprec_method_period' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Asset_family' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Asset_family_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Asset_group' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Asset_group_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Asset_history' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Asset_insurance' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Asset_investment_history' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Asset_leasing' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Asset_location' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Asset_location_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Asset_maintenance' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Assortment' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Assortment_item_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Assortment_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'ATS_time_period_balance' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'ATT_cust_list_column' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'ATT_cust_list_column_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'ATT_customized_list' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'ATT_customized_list_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'ATT_list_column_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'ATT_time_period_balance' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'ATT_time_period_constraint' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'ATT_totalizator_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'AUTO_to_round$' AS [TABLE_NAME], NULL AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Automatic_data_acquisition' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'AX_item_mappings_rules' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'AX_user_data_area_mapping' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Bank_card' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Bank_card_detail' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Bank_card_transaction' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Batch_run' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Batch_type' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Batch_type_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Bmc_application_default' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Bmc_application_default_backup_vesta_migration' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Bmc_application_key' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Bmc_application_key_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Bmc_authorized_task' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Bmc_batch_type' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Bmc_batch_type_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Bmc_context' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Bmc_context_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Bmc_desktop_property' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Bmc_form_preference' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Bmc_form_property' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Bmc_group_level_security' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Bmc_ID_counter' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Bmc_license' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Bmc_license_task_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Bmc_role' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Bmc_role_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Bmc_row_level_security' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Bmc_system' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Bmc_task' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'BMC_task_log' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Bmc_task_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Bmc_user_profile' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Bmc_user_role' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'BMH_rule_type_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'BML_rule_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'BMOH_formula_variable' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'BMOH_selected_rule' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'BOM_header' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'BOM_line' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'BOM_location' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'BOM_option_header' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'BOM_revision' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'BOM_rule' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'BOM_rule_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'BOM_rule_type' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'BOM_rule_type_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Booth' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Brand' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Brand_AD_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Brand_OU_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Brand_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Budget_type' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Budget_type_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Button' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Button_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'BVR_header' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'BVR_line' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'BVR_member' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'BVR_type' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Calendar_detail' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Calendar_header' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Calendar_header_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Card' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Cash_report_header' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Cash_report_line' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'CCI_address' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'CCI_address_key' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'CCI_ATA' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'CCI_ATA_guarantee' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'CCI_document_header' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'CCI_item' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'CCI_PD_deposit_code' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'CCI_reminder' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'CLK_group' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'CLK_group_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'CLK_user_interface' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Clocking' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Clocking_key' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Clocking_message' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Clocking_message_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Clocking_summary' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Clocking_terminal' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Clocking_terminal_profile' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'CLT_authorized_CLKG' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'CLTP_schedule' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'CLTP_user_interface' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'CNCI_addr' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Comm_price_master_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Commercial_price_detail' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Commercial_price_master' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Communication_history' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Company' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Contact_person' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Contract_daily_time' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Contract_daily_time_detail' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Contract_time_adjustment' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Contract_time_table_date' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Contract_time_table_detail' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Contract_time_table_header' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Cost_acc_plausibility' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Cost_accounting_type' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Cost_accounting_type_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Cost_entry' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Country' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Country_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'CR_receipt_detail' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'CR_receipt_input_schema' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'CR_receipt_master' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'CR_receipt_POS' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Credit_card_company' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Criteria' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Criteria_schema_detail' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Criteria_schema_header' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Criteria_schema_values' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Criteria_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Criteria_type' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Criteria_type_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'CRS_batch_run' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'CRS_document_header' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'CSH_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Currency' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Currency_account' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Currency_rate' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Currency_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Custom_export_licence' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Custom_export_licence_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Customer' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Customer_card' AS [TABLE_NAME], NULL AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Data_interface_status' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'DBA_change_tracking' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'DBA_change_tracking_DWH' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'DBA_change_tracking_template' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'DBA_change_tracking_version' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'DBA_Mailing_list' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'DBA_Servers_Monitoring' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'DBA_Working_hours' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Default_journal' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Delivery_code' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Delivery_code_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Delivery_cost' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Delivery_cost_DC_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Delivery_cost_detail' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Delivery_cost_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Department' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Department_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Depreciation_method' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Depreciation_method_period' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'DH_address_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'DH_criteria' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'DH_customer_card_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'DH_facility_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'DH_loyalty_card' AS [TABLE_NAME], NULL AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'DH_pre_calc_header' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'DH_pre_calc_quantity' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'DH_pre_calc_surplus' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'DH_signature' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'DH_status_history' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'DiscountVoucher' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'DiscountVoucher_FS_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'DiscountVoucherCondition' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'DiscountVoucherLinkOU' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'DiscountVoucherText' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'DL_alloy_batch' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'DL_BML_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'DL_criteria' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'DL_planning' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'DL_posology' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'DL_pre_calc_material' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'DL_pre_calc_process_line' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'DL_quantity_formula' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'DL_unit_price_breakdown' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'DL_WKOP_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'DMSSTAT_RSTATS' AS [TABLE_NAME], N'Y' AS [Other], N'red-gate data masker data' AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'DMSSTAT_TSTATS' AS [TABLE_NAME], N'Y' AS [Other], N'red-gate data masker data' AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Doc_header_customs_info' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Document_copy' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Document_counter' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Document_date' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Document_error' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Document_error_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Document_header' AS [TABLE_NAME], NULL AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Document_header_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Document_header_revision' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Document_header_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Document_line' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Document_line_date' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Document_line_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Document_periodicity' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Document_periodicity_date' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Document_transfer_method' AS [TABLE_NAME], NULL AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Document_type' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Document_type_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'DT_address' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'DT_cash_register' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'DT_device' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'DT_document_header' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'DT_document_line' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'DT_registration' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'DT_registration_address' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'dtproperties' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'DVACSpecificTargetItem' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'DVActionDefinition' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'DVCouponActionDefinition' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'DVCouponActionDefinitionText' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'DVCouponActionDefPrinting' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'DVPackageElement' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'DWT_Item_Search_Itk' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'DWT_Item_Search_Ittx' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'DWT_Item_Search_PHGDSC' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'EAS_APS_address_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'EAS_APS_op_link_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'EAS_APS_operation_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'EAS_file_header' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'EAS_file_line' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'EAS_structure' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'EAS_structure_operation' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'EAS_structure_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'EAS_structure_trigger' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'EDI_DTA' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'EDI_DTA_entry_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'EDI_DTA_PCA_payment_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'EDI_DTA_PIH_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'EDI_DTA_structure' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'EDI_DTA_structure_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Effective_pre_cost_entry' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Effective_pre_entry_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Effective_preliminary_entry' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Effective_time' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'EFT_OW_method' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'EFT_OW_method_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'EFT_OW_pre_entry' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'EFT_OW_rule' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'EFT_terminal' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'EFT_terminal_OU_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'EFT_terminal_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Element_account' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Element_transaction' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Email_pattern' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'EMC_absence' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'EMC_certificate_layout' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'EMC_criteria' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'EMC_loan' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'EMC_multi_profile' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'EMC_payment_method' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'EMC_payroll_period' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'EMC_payroll_variable' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'EMC_periodicity' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'EMC_termination_reason' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'EMC_termination_reason_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'EMC_termination_type' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'EMC_termination_type_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'EMCH_payroll_period_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Employee' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Employee_work_plan' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Employment_contract' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Employment_contract_history' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Ems_address' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'EMS_deposit' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Ems_room' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Ems_stay' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'EMSS_DL_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Entry' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Entry_key' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Entry_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Entry_reconciliation' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Entry_type' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Entry_type_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'EPD_provider' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'EPP_status_history' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'ERP_role' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'ERP_role_mapping' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'ERP_role_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Ethnic_group' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Ethnic_group_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Event' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Event_catalogue' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Event_catalogue_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Event_contact_address' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Event_premise' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Event_registration' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Event_sector' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Event_service' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'External_entry' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'External_file' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'External_file_section' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'External_file_section_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'External_file_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'External_preliminary_entry' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'FA_account_periodicity' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'FA_RAFAM_type' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'FA_RAFAM_type_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Facility' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Facility_address_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Facility_technical_criteria' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Family_allowance' AS [TABLE_NAME], NULL AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Family_allowance_account' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Family_allowance_history' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Family_allowance_journal' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Family_allowance_tariff' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Family_technical_criteria' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Filestream' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Financial_institution' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Financial_relation_account' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Fiscal_year' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Fixed_price' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'fixed_price_Pmed_bkp' AS [TABLE_NAME], NULL AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Form_property_model' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'FP_unit_price_breakdown' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'FTC_authorized_value' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'FUN_OUSH_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'GaldatItemsWithStatus' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Hotline' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'HR_certificate' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'HR_certificate_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'HR_evaluation_detail' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'HR_evaluation_master' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'HR_header' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'HR_language_skill' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'HR_prof_experience' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'HR_skill' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'HR_skill_level' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'HR_skill_level_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'HR_skill_type' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'HR_skill_type_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'HR_training' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'HR_training_attendee' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'HR_training_course' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'HR_training_course_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'HR_training_field' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'HR_training_field_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'HR_training_type' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'HR_training_type_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'HR_warning' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Incident_detail' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Incident_header' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Incident_type' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Incident_type_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'IND_DH_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'IND_status_history' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'INS_PD_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Insurance_network' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Insurance_network_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Insurance_policy' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'INT_PD_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Inter_OU_entry' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Inter_OU_pre_entry' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Inter_OU_pre_ET_master' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Inter_OU_pre_ET_master_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Interco_structure' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Interco_structure_target' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Interco_synchronization' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Interco_task' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Interco_task_PD_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Interco_task_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Inventory_batch' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Inventory_location' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Inventory_site' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Inventory_type' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Inventory_type_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Invitation' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Invoicing_method' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Invoicing_method_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'IT_categ_management_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'IT_category_management' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'IT_change_request' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'IT_config_setting' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'IT_ITCM_history' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'IT_label_print_log' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'IT_weighing_category' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'IT_weighing_category_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'ITCAT_IT_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'ITCAT_OUST_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'ITCHR_consequence' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'ITCHR_item_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'ITCHR_status_history' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'ITCOSTA_CR_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Item' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Item_alloy' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Item_alloy_quantity' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Item_attachment' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Item_catalog' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Item_catalog_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Item_context' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Item_context_status' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Item_context_status_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Item_context_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Item_criteria' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Item_dispatch_header' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Item_dispatch_line' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Item_family' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Item_family_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Item_group' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Item_group_def_accounting' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Item_group_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Item_inventory' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Item_key' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Item_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Item_location' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Item_LORE_min_max' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Item_manufacturing' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Item_price_range' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Item_price_range_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Item_process' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Item_purchase' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Item_quantity' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Item_regulation' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Item_relation_info' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Item_revision' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Item_sale' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Item_seasonal_stock_info' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Item_shipping' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Item_site' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Item_standard_cost' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Item_statistics' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Item_statistics_monthly' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Item_statistics_yearly' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Item_status_history' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Item_technical_criteria' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Item_terms' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Item_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Item_text_planned' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Item_unit_conversion' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'ITTC_history' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'JAL_authorized_ACPE' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Job_function' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Job_function_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Journal' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Knowledge_base' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Knowledge_base_category' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Knowledge_base_key' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Knowledge_category' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Knowledge_category_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'LAN_app_equivalence' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Language' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Language_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Leasing' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Ledger' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Ledger_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Linked_document' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'LORE_average_sales_qty' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'LORE_calculation_log' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'LORE_evaluation_period' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'LORE_item_ABC_code' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'LORE_item_facing' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'LORE_management_level' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'LORE_poisson_coefficient' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'LORE_rotation_ABC' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'LORE_rotation_ABC_detail' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'LORE_service_level_rate' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'LORE_statistical_period' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'LORE_store_opening_days' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'LORE_supplying_procedure' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'LORE_wilson_corr_fact_criteria' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'LORE_wilson_correction_factor' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'LORE_wilson_interest_rate' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'LORE_wilson_logistics_cost' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'LORE_wilson_purchasing_cost' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'LORE_z_coefficient' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Loyalty_card' AS [TABLE_NAME], NULL AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Machine' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Machine_downtime' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Machine_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Machine_time' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'MAFAM_item_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'MAG_ad' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'MAG_ad_item' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'MAG_ad_status_history' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'MAG_ad_type' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'MAG_ad_type_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'MAG_page' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'MAG_status_history' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'MAGAD_DL_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'MAGAD_technical_criteria' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Magazine' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Magazine_type' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Magazine_type_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Maintenance' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Maintenance_contract' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Manual_clocking' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Manufacturer' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Margin_class' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Margin_class_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Margin_factor_detail' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Margin_factor_master' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Margin_factor_master_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Marital_status' AS [TABLE_NAME], NULL AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Marketing_action_detail' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Marketing_activity_header' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Marketing_type' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Marketing_type_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Material_requirement' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Material_requirement_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Modifier_definition' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Modifier_exclusion' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'MRP_log' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'MSchange_tracking_history' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Numerary_value' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Object_merge_log' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Occupation' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Occupation_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'OFFCLD_reject' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Offline_clocking' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Offline_clocking_detail' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Operation' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Operation_role' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'OPT_DH_info' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'OPT_measure' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'OPT_task_info' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Organizational_unit' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'OU_advertising_space' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'OU_authorized_interco_task' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'OU_authorized_PD' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'OU_group' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'OU_group_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'OU_group_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'OU_item_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'OU_manager' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'OU_price_code_priority' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'OU_store_history' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'OU_store_type' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'OU_store_type_budget' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'OU_store_type_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'OU_user_role' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'OUAS_DL_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'OUAS_technical_criteria' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Package_detail' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Package_doc_line_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Package_header' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Packing_list' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Packing_type' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Packing_type_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Payment_input_detail' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Payment_input_header' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Payment_method' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Payment_method_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Payment_proposal_bank' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Payment_proposal_batch' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Payment_terms' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Payment_terms_detail' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Payment_terms_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Payroll_batch' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Payroll_batch_bank' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Payroll_batch_detail' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Payroll_calc_detail' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Payroll_calculation' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Payroll_employee_profile' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Payroll_heading' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Payroll_heading_specs' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Payroll_heading_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Payroll_parameters' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Payroll_period' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Payroll_period_master' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Payroll_period_master_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Payroll_period_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Payroll_period_type' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Payroll_period_type_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Payroll_profile_detail' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Payroll_profile_master' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Payroll_profile_master_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Payroll_scale_date' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Payroll_scale_detail' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Payroll_scale_master' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Payroll_scale_master_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PCA_EMC_absence' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PCA_EMC_loan' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PCA_payment_method' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PCC_totalizator_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PCT_totalizator_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PD_default_address_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PD_item_group_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PD_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PD_minimum_amount' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PD_pre_cost_entry_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PEM_amount_breakdown' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PerformancePoint' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PerformancePointAggregation' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Periodic_document_model' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Periodicity_detail' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Periodicity_master' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Periodicity_master_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Periodicity_type' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Periodicity_type_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'pfs_gdi$' AS [TABLE_NAME], NULL AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PH_APOS_item_status' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PH_Clinical_Check' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PH_Clinical_Check_Text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PH_Clinical_Check_Type' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PH_Clinical_Check_Type_Text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PH_custom_insurance_plan' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PH_ins_plan_pattern' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PH_ins_plan_pattern_master' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PH_ins_plan_refund_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PH_insurance' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PH_insurance_agreement' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PH_insurance_card' AS [TABLE_NAME], NULL AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PH_insurance_card_validation_history' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PH_insurance_group' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PH_insurance_group_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PH_insurance_group_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PH_insurance_history' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PH_insurance_plan' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PH_insurance_recommendation' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PH_insurance_supplement' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PH_insurance_tax_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PH_invoice_header' AS [TABLE_NAME], NULL AS [Other], N'field PHIH_remark is an XML that will contain the patient name, address and contact' AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PH_item' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PH_item_commercial_rule' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PH_item_insurance_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PH_item_limitation' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PH_item_regulation_info' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PH_OICM_code' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PH_OICM_code_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PH_OICM_history' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PH_organizational_unit' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PH_patient' AS [TABLE_NAME], NULL AS [Other], N'PHP_birth_year contains the birth year of the patient. It must be synced with the main patient birthdate' AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PH_patient_clinical_check' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PH_patient_tax_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PH_payment_receipt' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PH_PHIPM_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PH_posology_code' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PH_posology_code_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PH_prescriber' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PH_Prescriber_ins_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PH_prescriber_role' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PH_prescription_header' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PH_prescription_line' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PH_product' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PH_refund_code' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PH_refund_code_relation' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PH_refund_code_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PH_sales_import' AS [TABLE_NAME], NULL AS [Other], N'fields PHSI_adderss_lastname and PHSI_address_firstname might need to be altered, but not sure if those reffres to a customer, a doctor or a employee' AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PH_spec_tariff_addr_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PH_spec_tariff_detail' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PH_spec_tariff_master' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PH_spec_tariff_master_txt' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PH_std_posology' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PH_std_posology_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PH_tax_history' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Pharmacy_indicator' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PHGD_ACSC' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PHGD_ACXI' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PHGD_Brevier' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PHGD_BrevierText' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PHGD_CODES' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PHGD_CODETXT' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PHGD_CommonStyleSheet' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PHGD_Compendium' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PHGD_CompendiumParagraph' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PHGD_CompendiumText' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PHGD_LIMITATION' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PHGD_LIMITTXT' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PHGD_product_form' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PHGD_SC' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PHGD_XI' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PHGD_XIM' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PHGD_XITXT' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PHID_alloy' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PHIP_date' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Phone_call_log' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Physical_inventory_detail' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Physical_inventory_master' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PJ_item_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PJ_pre_cost_entry_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PJS_layout_detail' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PJS_layout_detail_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PJS_layout_master' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PJS_layout_master_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PJS_task_selection' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PJS_totalizator_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PKD_DL_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Point_of_sale' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PPB_address_selection' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PPB_OU_selection' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PPB_payment_method' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PR_certificate_detail' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PR_certificate_header' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PR_certificate_layout' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PR_certificate_layout_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PR_cust_list_column' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PR_cust_list_column_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PR_customized_list' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PR_customized_list_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PR_global_value_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PR_global_value_link_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PR_official_list' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PR_official_list_col_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PR_official_list_column' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PR_official_list_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PR_periodicity_type' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PR_periodicity_type_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PRCH_EPP_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PRCH_status_history' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Pre_cost_entry' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Pre_cost_entry_master' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Pre_cost_entry_master_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Pre_entry_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Predefined_entry' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Predefined_entry_flow' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Predefined_entry_print_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Predefined_entry_rounding' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Prelim_entry_master_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Preliminary_entry' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Preliminary_entry_master' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Premise' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Premise_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Prescription' AS [TABLE_NAME], 'Y' AS [Other], N'Pas utilisé, mais à valider!!!' AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Prescription_task_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PRH_activity_type_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PRH_boundary' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PRH_boundary_history' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PRH_boundary_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PRH_complement' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PRH_complement_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PRH_item_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PRH_layout_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PRH_list_column_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PRH_period_type' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PRH_PRHC_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PRH_totalizator_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Price_code' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Price_code_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Price_element' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Price_element_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Price_modifier' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Price_type' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Price_type_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Print_style' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Print_style_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Pro_svc_psbl_answer' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Pro_svc_psbl_answer_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Pro_svc_question' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Pro_svc_question_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Pro_svc_received_answer' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Pro_svc_session' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Pro_svc_session_answer' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Process_document' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Process_document_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Process_header' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Process_line' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Process_line_antecedence' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Process_line_option' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Process_option' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Process_overlap_header' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Process_overlap_line' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Process_overlap_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Process_revision' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Process_sub_contractor' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Product_line' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Product_line_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Production_time' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Profit_cost_center' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Profit_cost_center_key' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Profit_cost_center_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Profit_cost_type' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Profit_cost_type_key' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Profit_cost_type_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Project' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Project_address_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Project_criteria' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Project_entry' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Project_key' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Project_resource' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Project_status_history' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Project_structure' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Project_structure_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Project_weighting' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PROL_column_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Prospection' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Prospection_amount' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Prospection_criteria' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Prospection_reason' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'PRPET_conversion' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'QRCodes' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Quantity_formula_detail' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Quantity_formula_master' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Quantity_formula_master_txt' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'RAFAM_action_monitor' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'RAFAM_notification' AS [TABLE_NAME], NULL AS [Other], N'RANO_child_security_number and RANO_benef_security_number might need to be treated' AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Reason' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Reason_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Receipt_summary' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'REG_status_history' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Registration' AS [TABLE_NAME], 'Y' AS [Other], N'REG_main_Address might need to be treated' AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Registration_booth_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Religion' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Religion_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Remark_type' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Remark_type_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Remedy' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Remedy_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Reminder_method' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Report' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Repository_update_log' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Room_category' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Room_category_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Salary_grade' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Salary_grade_funct_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Salary_grade_history' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Salary_grade_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Sales_rep_address_list' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Sales_representative' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Sales_tax_code' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Sales_tax_code_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Sales_tax_rate' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Sector' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Sector_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Security_custody' AS [TABLE_NAME], 'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Security_group' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Security_group_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Serial_number' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Serial_number_history' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Serial_number_status' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Serial_number_status_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Sheet1$' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Shipping_method' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Shipping_method_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Signature_schema' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Signature_schema_detail' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Signature_schema_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Signboard' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Signboard_contract' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Signboard_DL_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Signboard_location' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Signboard_location_hist' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Signboard_per_status_hist' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Signboard_periodicity' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Signboard_type' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Signboard_type_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'SP_catalog' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'SP_catalog_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'SQL_connection' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'SSSI_OU_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Standard_cost_param' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Standard_cost_rate' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Standard_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Standard_text_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Standard_text_type' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Standard_text_type_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Standard_unit_conversion' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'STASD_event' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Statistic' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Statistic_OU_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Status' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Status_schema' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Status_schema_detail' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Status_schema_header' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Status_schema_header_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Status_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Status_type' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Status_type_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Stock_trans_effective_cost' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Stock_trans_type' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Stock_trans_type_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Stock_transaction' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Stock_transaction_master' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Stock_transaction_master_log' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'STT_PD_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Sub_contractor_terms' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'SUB_RAFAM_parameter' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Subsidiary' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Supplier' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Surplus_header' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Surplus_header_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Surplus_line' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Swiss_AVS_structure' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Swiss_bank_clearing' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Swiss_customs_detail' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Swiss_EMCH_supplement' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Swiss_payroll_parameters' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Symptom' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Symptom_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'sysdiagrams' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'System_email' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'System_site' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'System_site_link_auth' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'System_site_SQL_instance' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'System_site_SUB_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'System_site_transfer' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Tariff' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Tariff_type' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Tariff_type_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Task' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Task_address_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Task_budget_detail' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Task_criteria' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Task_key' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Task_progress_history' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Task_resource' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Task_status_history' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TC_authorized_value' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Tech_criteria_value' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Tech_criteria_value_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Technical_criteria' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Technical_criteria_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Telecom' AS [TABLE_NAME], NULL AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Terms_schema_detail' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Terms_schema_header' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Terms_schema_header_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Time_period' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Time_period_master' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Time_period_master_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Time_period_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Time_sheet_rate' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Time_sheet_special_rate' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Time_table_schema' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Time_table_schema_date' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Time_table_schema_detail' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Time_table_schema_history' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Time_table_schema_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Time_table_type' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Time_table_type_detail' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Time_table_type_history' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Time_table_type_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Title' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Title_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TK_pre_cost_entry_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Transaction_header' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Transaction_line' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TriaScan_Document' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_AC_ACPE_lock' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_Account_Statement' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_ACS_dataset' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_Address_Extraction' AS [TABLE_NAME], NULL AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_Auto_Data_Acquisition' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_BCR_RECAP_T2' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_BCR_WKO' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_Bmc_application_default_backup_vesta_migration' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_BOM' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_BRE_Plan_Fab_Index' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_CICR_LD_PCEM' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_Clocking_Key_Status' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_DH_auto_addr' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_DH_auto_document_line' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_DH_generation' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_DH_Manual_Stock_Allocation' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_DH_transitory' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_DL' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_DL_generation' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_DL_Part_List_Exchange' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_DL_planning' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_doc_line_date' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_DWH_discount_voucher' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_DWH_price_modifier_extraction' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_DWH_sales_extraction' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_EMC' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_EMC_Security' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_EPP' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_EPP_Withholding_Tax' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_Export_AC' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_Export_ACBARCODE' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_Export_ACNAM' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_Export_NETART_ACTION' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_Export_NETART_GREEN' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_Export_S13' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_Export_WHSPRICE' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_extraction_timestamp' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_File_Transfer' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_fixed_price_pricing' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_FUN_OUSH_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_GAL_Price_Factor' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_Galenicare_Bonart' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_GetNext_ID' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_IMP_bom_item' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_IMP_DL' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_IMP_DL_1' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_IMP_item' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_IMP_item_2' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_IMP_item_conso' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_IMP_item_cover_date' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_IMP_item_PL' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_IMP_item_PL_Tot' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_IMP_item_stock' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_IMP_Matr' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_IMP_wko' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_INB_generation' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_IT' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_IT_monthly_stat' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_ITCAT' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_ITCAT_OUST_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_ITDH_Send' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_item_availability_check' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_item_criteria' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_Item_Dispatch_Load' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_Item_Fixed_Price' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_Item_large_generic_sequence' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_Item_Popup_Text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_Item_Popup_Text_Overlap' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_Item_Relation_Info' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_Item_seasonal_stock_info' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_Item_Status' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_ITQ_Export' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_ITSH_generation' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_LD_budget' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_LD_CCI_ATA_online' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_LD_DH_FINA' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_LD_Doc_Line' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_LD_EMC_Payroll_Var' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_LD_EMC_periodicity' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_LD_Entry' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_LD_Fixed_Price' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_LD_Fixed_Price_Factor' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_LD_generic_item' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_LD_IT_Category_management' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_LD_Item_Visilab' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_LD_PR_Employee_Profile' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_LORE_item_facing' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_LORE_Label_Printing' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_LORE_wilson_correction_factor' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_OU_advertising_move' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_OU_advertising_process' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_OU_Price_Code_Priority' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_OU_store_history' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_Payroll_Stat' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_PCA' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_PH_APOS_item_status' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_PH_ITQ_Import' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_PH_purchase_condition' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_PH_purchase_dashboard' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_PH_purchase_order_error' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_PH_Purchase_Physician' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_PH_purchase_price' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_PH_RG_Label_Print' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_PHFCM_extraction' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_PHGD_Exp_AC' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_PHGD_Exp_ACBARCODE' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_PHGD_Exp_ACNAM' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_PHGD_Exp_NETART_ACTION' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_PHGD_Exp_NETART_GREEN' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_PHGD_Exp_WHSPRICE' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_PHGD_Fixed_Price' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_Physical_Inventory_Detail_Load' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_Physical_Inventory_Detail_Load_Archived' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_PIH_Source_FNRA_Update' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_PRCH' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_Pre_Calc' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_Search_Address' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_Search_DH' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_Search_DH_Total' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_Search_HR_Header' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_Search_Item' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_Serial_Number' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_signboard_contract_invoicing' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_SN_DH_WKO' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_ST' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_STM' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_SUN_Web_Item' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_Synchro' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_Synchro_Account_List' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_Synchro_Item_List' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_Tax_List_Recap' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_TXT_DL' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_User_Badge_Identifier' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_Visilab_AD_AMR_regular_import' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_Visilab_address_data_regular_import' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_Visilab_ADG_AMR_regular_import' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_Visilab_data_regular_import' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_Visilab_IT_AMR_regular_import' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_Visilab_item_data_regular_import' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_VMI' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_Web_Item' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_WKO' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_WKOP' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TT_XML_goods_receiving' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'TTSNH_authorized_status' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Unit_code' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Unit_code_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'User_card' AS [TABLE_NAME], N'Y' AS [Other], N'Carte employé pharmacie' AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Variable_price' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'VAT_period' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'VAT_period_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Vehicle' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Vehicle_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Vendor_managed_inv_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Vendor_managed_inventory' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'VIP_card' AS [TABLE_NAME], NULL AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'VIP_card_issue_type' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'VIP_card_type' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'VIP_card_type_link' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'VIP_card_type_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'VIP_deny_discount' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'VIPCT_marketing_type' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Web_service_access' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Web_service_access_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Weekly_schema_detail' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Weekly_schema_header' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'WKOP_assignment' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'WKOP_external_reference' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'WKOP_planning' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'WKOP_planning_header' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'WKPA_capacity' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Work_center' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Work_center_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Work_location' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Work_location_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Work_order' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Work_order_BOM_location' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Work_order_cost' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Work_order_process' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Work_order_process_qty' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Work_order_status_history' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Work_permit' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Work_sheet_header' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Work_type' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Work_type_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Workplace' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Workplace_text' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'WSA_connection' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'ZDBA_localisation' AS [TABLE_NAME], NULL AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'Zip_code' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dbo' AS [TABLE_SCHEMA], N'ZIP_distance_chart' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'dnz' AS [TABLE_SCHEMA], N'ItemSearch' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'repl' AS [TABLE_SCHEMA], N'ArticleColumnException' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'repl' AS [TABLE_SCHEMA], N'ArticleConfiguration' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'repl' AS [TABLE_SCHEMA], N'PublicationConfiguration' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'upd' AS [TABLE_SCHEMA], N'Change_tracking_monitor' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'upd' AS [TABLE_SCHEMA], N'DatabaseHistory' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'upd' AS [TABLE_SCHEMA], N'IA_IndexAlignementActions' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'upd' AS [TABLE_SCHEMA], N'MigrationScriptHistory' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'upd' AS [TABLE_SCHEMA], N'RunOnceScriptHistory' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'vesta' AS [TABLE_SCHEMA], N'Commvault_last_backup' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'wkl' AS [TABLE_SCHEMA], N'ActiveStockEventLog' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'wkl' AS [TABLE_SCHEMA], N'ArizonaToWKLDataTransformationLog' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'wkl' AS [TABLE_SCHEMA], N'AutoExpiryDateRule' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'wkl' AS [TABLE_SCHEMA], N'DeliveryNote' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'wkl' AS [TABLE_SCHEMA], N'DocumentSignature' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'wkl' AS [TABLE_SCHEMA], N'GoodsReceipt' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'wkl' AS [TABLE_SCHEMA], N'GoodsReceiptLine' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'wkl' AS [TABLE_SCHEMA], N'GoodsReceiptLineDetail' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'wkl' AS [TABLE_SCHEMA], N'GoodsReceiptScanHistory' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'wkl' AS [TABLE_SCHEMA], N'ItemOrderCondition' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'wkl' AS [TABLE_SCHEMA], N'ItemSalesStatistics' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'wkl' AS [TABLE_SCHEMA], N'MissedSale' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'wkl' AS [TABLE_SCHEMA], N'OrderRequest' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'wkl' AS [TABLE_SCHEMA], N'OrderRequestLine' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'wkl' AS [TABLE_SCHEMA], N'POCustomerReference' AS [TABLE_NAME], NULL AS [Other], NULL AS [Comment] UNION ALL SELECT N'wkl' AS [TABLE_SCHEMA], N'PODNLink' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'wkl' AS [TABLE_SCHEMA], N'PolLinkLog' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'wkl' AS [TABLE_SCHEMA], N'PolTransmissionResponse' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'wkl' AS [TABLE_SCHEMA], N'POMergeLog' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'wkl' AS [TABLE_SCHEMA], N'PurchaseOrder' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'wkl' AS [TABLE_SCHEMA], N'PurchaseOrderLine' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'wkl' AS [TABLE_SCHEMA], N'PurchaseOrderLineDetail' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'wkl' AS [TABLE_SCHEMA], N'PurchaseReturn' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'wkl' AS [TABLE_SCHEMA], N'PurchaseReturnLine' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'wkl' AS [TABLE_SCHEMA], N'ServiceBrokerError' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'wkl' AS [TABLE_SCHEMA], N'TriggerEvent' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] UNION ALL SELECT N'wkl' AS [TABLE_SCHEMA], N'ZoneDeliveryRule' AS [TABLE_NAME], N'Y' AS [Other], NULL AS [Comment] ) t; UPDATE ti SET [ti].[command]= 'ADD SENSITIVITY CLASSIFICATION TO '+[c].[TABLE_SCHEMA]+'.'+[c].[TABLE_NAME]+'.'+[c].[COLUMN_NAME]+' WITH ( LABEL=''General'', INFORMATION_TYPE=''Other'', RANK=Low )' FROM [#tables_to_ignore] ti JOIN [INFORMATION_SCHEMA].[COLUMNS] c ON c.[TABLE_NAME] = ti.[TABLE_NAME] AND c.[TABLE_SCHEMA] = ti.[TABLE_SCHEMA] WHERE ti.[Other] ='y'; --SELECT * --FROM [#tables_to_ignore] DECLARE crsr_set_to_other CURSOR FAST_FORWARD READ_ONLY FOR SELECT [ti].[command] FROM [#tables_to_ignore] ti JOIN [INFORMATION_SCHEMA].[COLUMNS] c ON c.[TABLE_SCHEMA] = ti.[TABLE_SCHEMA] AND c.[TABLE_NAME] = ti.[TABLE_NAME] OPEN crsr_set_to_other FETCH NEXT FROM crsr_set_to_other INTO @cmd WHILE @@FETCH_STATUS = 0 BEGIN EXEC(@cmd); FETCH NEXT FROM crsr_set_to_other INTO @cmd END CLOSE crsr_set_to_other DEALLOCATE crsr_set_to_other --#endregion --#region set all fields ending with GUID as "Other - general" INSERT @cols_to_add_other_guid ([schema_name], [table_name], [column_name], [command]) SELECT ic.[TABLE_SCHEMA], ic.[TABLE_NAME], ic.[COLUMN_NAME], 'ADD SENSITIVITY CLASSIFICATION TO '+[ic].[TABLE_SCHEMA]+'.'+[ic].[TABLE_NAME]+'.'+[ic].[COLUMN_NAME]+' WITH ( LABEL=''General'', INFORMATION_TYPE=''Other'', RANK=Low )' FROM [INFORMATION_SCHEMA].[COLUMNS] ic JOIN [INFORMATION_SCHEMA].[TABLES] it ON it.[TABLE_SCHEMA] = ic.[TABLE_SCHEMA] AND it.[TABLE_NAME] = ic.[TABLE_NAME] WHERE [it].[TABLE_TYPE] = 'BASE TABLE' AND [ic].[COLUMN_NAME] LIKE '%guid' DECLARE crsr_to_other_guid CURSOR FAST_FORWARD READ_ONLY FOR SELECT command FROM @cols_to_add_other_guid OPEN crsr_to_other_guid FETCH NEXT FROM crsr_to_other_guid INTO @cmd WHILE @@FETCH_STATUS = 0 BEGIN --PRINT @cmd; EXEC(@cmd); FETCH NEXT FROM crsr_to_other_guid INTO @cmd END CLOSE crsr_to_other_guid DEALLOCATE crsr_to_other_guid --#endregion /* TODO: * All FK / PK must be excluded * keep text / xml and numeric types only */ --#region switch active Galenica type to inactive for tables to exclude UPDATE tt SET [toExclude] = 1, [reasonToExclude] = 'known not used anymore' FROM [#tblToExclude] tt JOIN @unused u ON [u].[schemaName] = [tt].[schemaName] AND u.[tblName] = tt.[tableName] WHERE tt.[toExclude] = 0 ; PRINT CONVERT(VARCHAR(20), CURRENT_TIMESTAMP, 114)+' - Excluded because known to not be of use. '+REPLACE(REPLACE(CONVERT(VARCHAR(100), CONVERT(MONEY, @@rowcount), 1),',',''''),'.00','')+' row(s) affected.'; DECLARE crs_inactive CURSOR FAST_FORWARD READ_ONLY FOR SELECT schema_name(o.[schema_id])+'.'+o.[name]+'.'+c.[name] AS col FROM sys.sensitivity_classifications sc JOIN sys.objects O ON sc.major_id = O.object_id JOIN sys.columns C ON sc.major_id = C.object_id AND sc.minor_id = C.column_id JOIN [#tblToExclude] tt ON tt.[schemaName] = schema_name(o.[schema_id]) AND tt.[tableName] = o.[name] WHERE CAST(sc.[information_type] AS VARCHAR(500)) = 'Galenica Active Personal Informations' AND tt.[toExclude] = 1 OPEN crs_inactive FETCH NEXT FROM crs_inactive INTO @col WHILE @@FETCH_STATUS = 0 BEGIN EXEC('ADD SENSITIVITY CLASSIFICATION TO '+@col+' WITH ( LABEL=''Confidential'', INFORMATION_TYPE=''Galenica Inactive Personal Informations'', RANK=High ) '); --PRINT CONVERT(VARCHAR(20), CURRENT_TIMESTAMP, 114)+' - Switched '+@col+' to type ''Galenica Inactive Personal Informations'' '; FETCH NEXT FROM crs_inactive INTO @col END CLOSE crs_inactive DEALLOCATE crs_inactive --#endregion --#region Set PK's to "other - general" DECLARE crsr_pk CURSOR FAST_FORWARD READ_ONLY FOR SELECT 'ADD SENSITIVITY CLASSIFICATION TO '+SCHEMA_NAME([tab].[schema_id])+'.'+tab.[name]+'.'+d.[column_names]+' WITH (LABEL=''General'', INFORMATION_TYPE=''Other'', RANK=Low ) ' AS command FROM sys.tables tab LEFT OUTER JOIN sys.indexes pk ON tab.object_id = pk.object_id AND [pk].[is_primary_key] = 1 OUTER APPLY ( SELECT [col].[name] FROM sys.index_columns ic INNER JOIN sys.columns col ON ic.object_id = col.object_id AND ic.column_id = col.column_id WHERE ic.object_id = tab.object_id AND [ic].[index_id] = pk.index_id) D(column_names) WHERE [D].[column_names] IS NOT NULL ORDER BY SCHEMA_NAME([tab].[schema_id]), tab.[name]; OPEN crsr_pk FETCH NEXT FROM crsr_pk INTO @cmd WHILE @@FETCH_STATUS = 0 BEGIN EXEC(@cmd) FETCH NEXT FROM crsr_pk INTO @cmd END CLOSE crsr_pk DEALLOCATE crsr_pk --#endregion --#region set FK's to "other - general" DECLARE crsr_FK CURSOR FAST_FORWARD READ_ONLY FOR SELECT 'ADD SENSITIVITY CLASSIFICATION TO '+SCHEMA_NAME(t.[schema_id])+'.'+t.[name]+'.'+pc.name+' WITH (LABEL=''General'', INFORMATION_TYPE=''Other'', RANK=Low ) ' AS command FROM sys.foreign_key_columns AS fkc INNER JOIN sys.foreign_keys AS fk ON fkc.constraint_object_id = fk.object_id INNER JOIN sys.tables AS t ON fkc.parent_object_id = t.object_id INNER JOIN sys.tables AS rt ON fkc.referenced_object_id = rt.object_id INNER JOIN sys.columns AS pc ON fkc.parent_object_id = pc.object_id AND fkc.parent_column_id = pc.column_id INNER JOIN sys.columns AS c ON fkc.referenced_object_id = c.object_id AND fkc.referenced_column_id = c.column_id OPEN crsr_FK FETCH NEXT FROM crsr_FK INTO @cmd WHILE @@FETCH_STATUS = 0 BEGIN EXEC(@cmd) FETCH NEXT FROM crsr_FK INTO @cmd END CLOSE crsr_FK DEALLOCATE crsr_FK --#endregion --#region manually added classification ADD SENSITIVITY CLASSIFICATION TO ap.[StarcardValidity].[CardNumber] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[Address_monitor].[AM_old_name] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[Address_monitor].[AM_new_name] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[Address_monitor].[AM_old_social_security_number] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[Address_monitor].[AM_new_social_security_number] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[Address].[AD_name] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[Address].[AD_name_supplement] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[Address].[AD_first_name] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[Address].[AD_middle_name] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[Address].[AD_last_name] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[Address].[AD_address_1] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[Address].[AD_address_2] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[Address].[AD_address_3] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[Address].[AD_zip_code] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[Address].[AD_city] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[Address].[AD_state] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[Address].[AD_postal_routing_address] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[Address].[AD_sex] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[Address].[AD_social_security_number] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[Address].[AD_date_of_birth] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[Address].[AD_place_of_birth] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[Address].[AD_place_of_origin] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[Address].[AD_geo_address] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[Address].[AD_geo_zip_code] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[Address].[AD_geo_city] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[Address].[AD_geo_state] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[Address].[AD_geo_country] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[Address].[AD_geo_postal_routing_address] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[Customer_card].[CC_card_number] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[Customer_card].[CC_secret_number] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[DH_loyalty_card].[DHLC_card_number] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[Document_header].[DH_ship_to_text] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[Document_header].[DH_sold_to_text] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[Document_header].[DH_send_bill_to_text] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[Document_transfer_method].[DTM_email_recipients] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[Document_transfer_method].[DTM_email_carbon_copy] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[Document_transfer_method].[DTM_email_blind_carbon_copy] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[Family_allowance].[FAAL_last_name] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[Family_allowance].[FAAL_first_name] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[Family_allowance].[FAAL_middle_name] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[Family_allowance].[FAAL_date_of_birth] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[Family_allowance].[FAAL_place_of_birth] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[Family_allowance].[FAAL_nationality] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[Family_allowance].[FAAL_sex] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[Family_allowance].[FAAL_social_security_number] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[Loyalty_card].[LC_card_number] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[Loyalty_card].[LC_full_name] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[Marital_status].[MS_marital_status] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[PH_insurance_card].[PHIC_code] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[PH_insurance_card].[PHIC_code_right] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[PH_insurance_card].[PHIC_expiry_date] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[PH_insurance_card].[PHIC_debtor_first_name] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[PH_insurance_card].[PHIC_debtor_last_name] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[PH_invoice_header].[PHIH_remark] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[PH_patient].[PHP_birth_year] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO [dbo].[PH_sales_import].[PHSI_address_lastname] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO [dbo].[PH_sales_import].[PHSI_address_firstname] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO [dbo].[PH_sales_import].[PHSI_address_date_of_birth] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[RAFAM_notification].[RANO_child_social_sec_number] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[RAFAM_notification].[RANO_benef_social_sec_number] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[TT_Address_Extraction].[TTADE_cont_name] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[TT_Address_Extraction].[TTADE_cont_phone] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[TT_Address_Extraction].[TTADE_cont_fax] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[TT_Address_Extraction].[TTADE_cont_email] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[TT_Address_Extraction].[TTADE_cont_natel] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[TT_Address_Extraction].[TTADE_main_phone] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[TT_Address_Extraction].[TTADE_main_fax] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[TT_Address_Extraction].[TTADE_main_email] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[TT_Address_Extraction].[TTADE_main_natel] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[TT_Address_Extraction].[TTADE_TEL_number] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[TT_Address_Extraction].[TTADE_AD_name] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[TT_Address_Extraction].[TTADE_AD_address_1] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[TT_Address_Extraction].[TTADE_AD_address_2] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[TT_Address_Extraction].[TTADE_AD_address_3] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[TT_Address_Extraction].[TTADE_AD_zip_code] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[TT_Address_Extraction].[TTADE_AD_city] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[TT_Address_Extraction].[TTADE_AD_date_of_birth] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[TT_Address_Extraction].[TTADE_AD_sex] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[VIP_card].[VIPC_name_on_card] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[VIP_card].[VIPC_code] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[VIP_card].[VIPC_barcode] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO dbo.[VIP_card].[VIPC_alternative_barcode] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO wkl.[POCustomerReference].[CustomerName] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO wkl.[POCustomerReference].[Address] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO wkl.[POCustomerReference].[City] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); ADD SENSITIVITY CLASSIFICATION TO wkl.[POCustomerReference].[Phone] WITH ( LABEL='Confidential', INFORMATION_TYPE='Galenica Used Personal Informations', RANK=High ); --#endregion --#region Add every fields without classification in a table where at least 1 field is classified as "other - general" INSERT @cols_to_add_other ([schema_name], [table_name], [column_name], [command]) SELECT ic.[TABLE_SCHEMA], ic.[TABLE_NAME], ic.[COLUMN_NAME], 'ADD SENSITIVITY CLASSIFICATION TO '+[ic].[TABLE_SCHEMA]+'.'+[ic].[TABLE_NAME]+'.'+[ic].[COLUMN_NAME]+' WITH ( LABEL=''General'', INFORMATION_TYPE=''Other'', RANK=Low )' FROM [INFORMATION_SCHEMA].[COLUMNS] ic JOIN [INFORMATION_SCHEMA].[TABLES] it ON it.[TABLE_SCHEMA] = ic.[TABLE_SCHEMA] AND it.[TABLE_NAME] = ic.[TABLE_NAME] WHERE [it].[TABLE_TYPE] = 'BASE TABLE' AND NOT EXISTS( /* column is not classified */ SELECT SCHEMA_NAME([O].[schema_id]) AS schema_name, O.name AS table_name, C.name AS column_name FROM sys.sensitivity_classifications sc JOIN sys.objects O ON [sc].[major_id] = O.object_id JOIN sys.columns C ON [sc].[major_id] = C.object_id AND [sc].[minor_id] = [C].[column_id] WHERE SCHEMA_NAME([O].[schema_id]) = ic.[TABLE_SCHEMA] AND o.name = ic.[TABLE_NAME] AND c.name = ic.[COLUMN_NAME] ) AND EXISTS( /* but the table have at least 1 classified column */ SELECT 1 FROM sys.sensitivity_classifications sc JOIN sys.objects O ON [sc].[major_id] = O.object_id WHERE SCHEMA_NAME([O].[schema_id]) = ic.[TABLE_SCHEMA] AND o.name = ic.[TABLE_NAME] ) DECLARE crsr_to_other CURSOR FAST_FORWARD READ_ONLY FOR SELECT command FROM @cols_to_add_other OPEN crsr_to_other FETCH NEXT FROM crsr_to_other INTO @cmd WHILE @@FETCH_STATUS = 0 BEGIN --PRINT @cmd; EXEC(@cmd); FETCH NEXT FROM crsr_to_other INTO @cmd END CLOSE crsr_to_other DEALLOCATE crsr_to_other --#endregion --#region set rank=high on all classification not "other - general" DECLARE crsr_rank CURSOR FAST_FORWARD READ_ONLY FOR SELECT 'ADD SENSITIVITY CLASSIFICATION TO '+CAST(SCHEMA_NAME([O].[schema_id]) AS NVARCHAR(100))+'.'+CAST(o.[name] AS NVARCHAR(100))+'.'+CAST(c.name AS NVARCHAR(100))+' WITH ( LABEL='''+CAST(sc.[label] AS NVARCHAR(100))+''', INFORMATION_TYPE='''+CAST(sc.[information_type] AS NVARCHAR(100))+''', RANK=High)' AS command --sc.* FROM sys.sensitivity_classifications sc JOIN sys.objects O ON [sc].[major_id] = O.object_id JOIN sys.columns C ON [sc].[major_id] = C.object_id AND [sc].[minor_id] = [C].[column_id] WHERE CAST(sc.[information_type] AS VARCHAR(500)) <> 'Other' AND COALESCE([sc].[rank_desc],'') <> 'HIGH' OPEN crsr_rank FETCH NEXT FROM crsr_rank INTO @cmd WHILE @@FETCH_STATUS = 0 BEGIN EXEC(@cmd) FETCH NEXT FROM crsr_rank INTO @cmd END CLOSE crsr_rank DEALLOCATE crsr_rank --#endregion --SELECT * --FROM [#tblToExclude] --ORDER BY [reasonToExclude], [schemaName], [tableName] --ROLLBACK TRANSACTION COMMIT TRANSACTION