Two easiest command syntacx to disable /enable existing triggers on table are as below-
To Disable-
ALTER TABLE
[mySchemaName].[myTableName] DISABLE TRIGGER myTriggerName
; DISABLE TRIGGER
myTriggerName ON [mySchemaName].[myTableName]
To Enable-
ALTER TABLE [mySchemaName].[myTableName] ENABLE TRIGGER myTriggerName
; ENABLE TRIGGER myTriggerName ON [mySchemaName].[myTableName]
Join the conversation! Your thoughts help the community grow.