use Arizona_delphix

-- 'ALTER TABLE ' + @schema + '.' + @tableName + ' DISABLE CHANGE_TRACKING;'
SELECT 'Arizona' as Database_name, s.name AS Schema_name, t.name AS Table_name , 'ALTER TABLE ' + s.name + '.' + t.name + ' DISABLE CHANGE_TRACKING;'
FROM Arizona_delphix.sys.change_tracking_tables ctt
JOIN Arizona_delphix.sys.tables t 
    ON t.object_id = ctt.object_id
JOIN Arizona_delphix.sys.schemas s
    ON s.schema_id = t.schema_id
--WHERE s.name = 'dbo'
ORDER BY s.name, t.name;

return


ALTER TABLE AP.WebShopStatusQueue DISABLE CHANGE_TRACKING;
ALTER TABLE dbo.DL_posology DISABLE CHANGE_TRACKING;
ALTER TABLE dbo.Document_header DISABLE CHANGE_TRACKING;
ALTER TABLE dbo.Document_line DISABLE CHANGE_TRACKING;
ALTER TABLE dbo.Document_line_link DISABLE CHANGE_TRACKING;
ALTER TABLE dbo.Item_inventory DISABLE CHANGE_TRACKING;
ALTER TABLE dbo.Item_quantity DISABLE CHANGE_TRACKING;
ALTER TABLE dbo.Item_seasonal_stock_info DISABLE CHANGE_TRACKING;
ALTER TABLE dbo.Item_standard_cost DISABLE CHANGE_TRACKING;
ALTER TABLE dbo.LORE_item_ABC_code DISABLE CHANGE_TRACKING;
ALTER TABLE dbo.LORE_supplying_procedure DISABLE CHANGE_TRACKING;
ALTER TABLE dbo.PH_insurance_card DISABLE CHANGE_TRACKING;
ALTER TABLE dbo.PH_insurance_plan DISABLE CHANGE_TRACKING;
ALTER TABLE dbo.PH_insurance_recommendation DISABLE CHANGE_TRACKING;
ALTER TABLE dbo.PH_patient DISABLE CHANGE_TRACKING;
ALTER TABLE dbo.PH_prescription_header DISABLE CHANGE_TRACKING;
ALTER TABLE dbo.PH_prescription_line DISABLE CHANGE_TRACKING;
ALTER TABLE dbo.Price_modifier DISABLE CHANGE_TRACKING;
ALTER TABLE wkl.DocumentSignature DISABLE CHANGE_TRACKING;
ALTER TABLE wkl.GoodsReceipt DISABLE CHANGE_TRACKING;
ALTER TABLE wkl.GoodsReceiptLine DISABLE CHANGE_TRACKING;
ALTER TABLE wkl.MissedSale DISABLE CHANGE_TRACKING;
ALTER TABLE wkl.OrderRequest DISABLE CHANGE_TRACKING;
ALTER TABLE wkl.OrderRequestLine DISABLE CHANGE_TRACKING;
ALTER TABLE wkl.PurchaseReturn DISABLE CHANGE_TRACKING;
ALTER TABLE wkl.PurchaseReturnLine DISABLE CHANGE_TRACKING;