42 lines
2.0 KiB
SQL
42 lines
2.0 KiB
SQL
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;
|