2286 lines
191 KiB
PL/PgSQL
2286 lines
191 KiB
PL/PgSQL
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<69>, mais <20> 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<6F> 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
|
||
|