Item Rename Part 2

DECLARE @ItemOld varchar(500)='TEST1'
DECLARE @ItemNew varchar(500)='TEST2'

BEGIN TRAN

--DROP a FK...
--ALTER TABLE [dbo].[item] DROP CONSTRAINT [FK_item_ILC_Item]

--<Do the update>

--ADD it back...
--ALTER TABLE [dbo].[item]  WITH CHECK ADD  CONSTRAINT [FK_item_ILC_Item] FOREIGN KEY([item])
--REFERENCES [dbo].[ILC_Item] ([item])

--ALTER TABLE [dbo].[item] CHECK CONSTRAINT [FK_item_ILC_Item]

;DISABLE TRIGGER poitemIup ON poItem
;DISABLE TRIGGER poitemUpdatePenultimate ON poItem
UPDATE poitem
SET item=@ItemNew
WHERE item = @ItemOld
;ENABLE TRIGGER poitemIup ON poItem
;ENABLE TRIGGER poitemUpdatePenultimate ON poItem

;DISABLE TRIGGER exc_mesgUpdatePenultimate ON exc_mesg
UPDATE exc_mesg
SET item=@ItemNew
WHERE item = @ItemOld
;ENABLE TRIGGER exc_mesgUpdatePenultimate ON exc_mesg

UPDATE poitem_all
SET item=@ItemNew
WHERE item = @ItemOld

;DISABLE TRIGGER itemwhseIup ON itemwhse
;DISABLE TRIGGER itemwhseUpdatePenultimate ON itemwhse
UPDATE itemwhse
SET item=@ItemNew
WHERE item = @ItemOld
;ENABLE TRIGGER itemwhseIup ON itemwhse
;ENABLE TRIGGER itemwhseUpdatePenultimate ON itemwhse

;DISABLE TRIGGER itemIup ON item
;DISABLE TRIGGER itemUpdatePenultimate ON item
UPDATE item
SET item=@ItemNew
WHERE item = @ItemOld
;ENABLE TRIGGER itemIup ON item
;ENABLE TRIGGER itemUpdatePenultimate ON item

;DISABLE TRIGGER item_glblIupReplicate ON item_glbl
;DISABLE TRIGGER item_glblUpdatePenultimate ON item_glbl
UPDATE item_glbl
SET item=@ItemNew
WHERE item = @ItemOld
;ENABLE TRIGGER item_glblIupReplicate ON item_glbl
;ENABLE TRIGGER item_glblUpdatePenultimate ON item_glbl

;DISABLE TRIGGER itemlocIup ON itemloc
;DISABLE TRIGGER itemlocUpdatePenultimate ON itemloc
UPDATE itemloc
SET item=@ItemNew
WHERE item = @ItemOld
;ENABLE TRIGGER itemlocIup ON itemloc
;ENABLE TRIGGER itemlocUpdatePenultimate ON itemloc

;DISABLE TRIGGER jobmatlIup ON jobmatl
;DISABLE TRIGGER jobmatlUpdatePenultimate ON jobmatl
UPDATE jobmatl
SET item=@ItemNew
WHERE item = @ItemOld
;ENABLE TRIGGER jobmatlIup ON jobmatl
;ENABLE TRIGGER jobmatlUpdatePenultimate ON jobmatl

UPDATE coitem_log_all
SET item=@ItemNew
WHERE item = @ItemOld

;DISABLE TRIGGER coitem_logUpdatePenultimate ON coitem_log
UPDATE coitem_log
SET item=@ItemNew
WHERE item = @ItemOld
;ENABLE TRIGGER coitem_logUpdatePenultimate ON coitem_log


;DISABLE TRIGGER jobIup ON job
;DISABLE TRIGGER jobUpdatePenultimate ON job
UPDATE job
SET item=@ItemNew
WHERE item = @ItemOld
;ENABLE TRIGGER jobIup ON job
;ENABLE TRIGGER jobUpdatePenultimate ON job

;DISABLE TRIGGER trnitemIup ON trnitem
;DISABLE TRIGGER trnitemUpdatePenultimate ON trnitem
UPDATE trnitem
SET item=@ItemNew
WHERE item = @ItemOld
;ENABLE TRIGGER trnitemIup ON trnitem
;ENABLE TRIGGER trnitemUpdatePenultimate ON trnitem

;DISABLE TRIGGER matltrackUpdatePenultimate ON matltrack
UPDATE matltrack
SET item=@ItemNew
WHERE item = @ItemOld
;ENABLE TRIGGER matltrackUpdatePenultimate ON matltrack

UPDATE matltrack_all
SET item=@ItemNew
WHERE item = @ItemOld

;DISABLE TRIGGER matltranIup ON matltran
;DISABLE TRIGGER matltranUpdatePenultimate ON matltran
UPDATE matltran
SET item=@ItemNew
WHERE item = @ItemOld
;ENABLE TRIGGER matltranIup ON matltran
;ENABLE TRIGGER matltranUpdatePenultimate ON matltran

UPDATE matltran_all
SET item=@ItemNew
WHERE item = @ItemOld

ALTER TABLE [dbo].[lot_loc] DROP  CONSTRAINT [lot_locFk3]

;DISABLE TRIGGER lotIup ON lot
;DISABLE TRIGGER lotUpdatePenultimate ON lot
UPDATE lot
SET item=@ItemNew
WHERE item = @ItemOld
;ENABLE TRIGGER lotIup ON lot
;ENABLE TRIGGER lotUpdatePenultimate ON lot

UPDATE lot_all
SET item=@ItemNew
WHERE item = @ItemOld

;DISABLE TRIGGER lot_locIup ON lot_loc
;DISABLE TRIGGER lot_locUpdatePenultimate ON lot_loc
UPDATE lot_loc
SET item=@ItemNew
WHERE item = @ItemOld
;ENABLE TRIGGER lot_locIup ON lot_loc
;ENABLE TRIGGER lot_locUpdatePenultimate ON lot_loc

UPDATE lot_loc_all
SET item=@ItemNew
WHERE item = @ItemOld

ALTER TABLE [dbo].[lot_loc]  WITH NOCHECK ADD  CONSTRAINT [lot_locFk3] FOREIGN KEY([item], [lot])
REFERENCES [dbo].[lot] ([item], [lot])

;DISABLE TRIGGER coitemIup ON coitem
;DISABLE TRIGGER coitemUpdatePenultimate ON coitem
UPDATE coitem
SET item=@ItemNew
WHERE item = @ItemOld
;ENABLE TRIGGER coitemIup ON coitem
;ENABLE TRIGGER coitemUpdatePenultimate ON coitem

;DISABLE TRIGGER preassigned_lotUpdatePenultimate ON preassigned_lot
UPDATE preassigned_lot
SET item=@ItemNew
WHERE item = @ItemOld
;ENABLE TRIGGER preassigned_lotUpdatePenultimate ON preassigned_lot

UPDATE preassigned_lot_all
SET item=@ItemNew
WHERE item = @ItemOld

UPDATE coitem_all
SET item=@ItemNew
WHERE item = @ItemOld

;DISABLE TRIGGER apsplanUpdatePenultimate ON apsplan
UPDATE apsplan
SET parent_item=@ItemNew
WHERE parent_item = @ItemOld
;ENABLE TRIGGER apsplanUpdatePenultimate ON apsplan

;DISABLE TRIGGER apsplandetailUpdatePenultimate ON apsplandetail
UPDATE apsplandetail
SET parent_item=@ItemNew
WHERE parent_item = @ItemOld
;ENABLE TRIGGER apsplandetailUpdatePenultimate ON apsplandetail

;DISABLE TRIGGER inv_itemUpdatePenultimate ON inv_item
UPDATE inv_item
SET item=@ItemNew
WHERE item = @ItemOld
;ENABLE TRIGGER inv_itemUpdatePenultimate ON inv_item

;DISABLE TRIGGER sale_sumUpdatePenultimate ON sale_sum
UPDATE sale_sum
SET item=@ItemNew
WHERE item = @ItemOld
;ENABLE TRIGGER sale_sumUpdatePenultimate ON sale_sum

;DISABLE TRIGGER RS_QCItemhIup ON RS_QCItemh
;DISABLE TRIGGER RS_QCItemhUpdatePenultimate ON RS_QCItemh
UPDATE RS_QCItemh
SET item=@ItemNew
WHERE item = @ItemOld
;ENABLE TRIGGER RS_QCItemhIup ON RS_QCItemh
;ENABLE TRIGGER RS_QCItemhUpdatePenultimate ON RS_QCItemh

UPDATE item_all
SET item=@ItemNew
WHERE item = @ItemOld

UPDATE itemwhse_all
SET item=@ItemNew
WHERE item = @ItemOld

UPDATE itemloc_all
SET item=@ItemNew
WHERE item = @ItemOld

COMMIT