Manohar

• Aug 15th, 2006

 

1. alter table <tname> enable/disable all triggers; (to disable all triggers on table).

2.alter table <tname>  enable/disable <trigger name>;(to disable specified trigger).

vishal

• Dec 28th, 2006

 

SQL:> Alter trigger trigger_name enable/disable;

krishnaindia2007

 Profile Answers by krishnaindia2007 

• Jun 22nd, 2008

 

To enalbe or disable  specific trigger
Alter trigger triggername enable/disable

To enalbe or disable all triggers on a table
Alter table tablename disable / enable all triggers

sampra

 Profile Answers by sampra 

• Mar 6th, 2012

 

Alter trigger trigger_name enable/disable;

aytasirs

 Profile Answers by aytasirs 

• Nov 15th, 2012

 

Alter trigger Disable;

vijaya

• May 11th, 2013

 

Alter trigger trigger_name disable/enable all triggers.

sanjay pradhan

• Sep 26th, 2014

 

Alter trigger trigger_name disable