How to disable a trigger for a particular table ?

Suppose if i have 8 triggers declared for a table..how to disable a single trigger from a table...
i don't want to disable all triggers for a table. I know we can disable all triggers by using "alter table disable all triggers;". just i want to know how to disable single trigger from a table.
  • Interview Candidate
  • 9
  • 3556

Showing Answers 1 - 9 of 9 Answers

Pervez

  • Mar 23rd, 2007
 

use following statement
alter trigger <trigger_name> disable

Pavan

  • Apr 3rd, 2007
 

Thanks parweej,
alter trigger <trigger-name> disable
worked for me..

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions