Removing a trigger

[davidvilla]

How to remove a table level trigger? I know, I can do that using the SCHEMA-> MODIFY TABLE menu. Is there a command to do that?

 

[jdpjamesp]

You can temporarily override the triggers using

ON WRITE (or delete, create, etc) OF TABLE OVERRIDE DO: END.
<processing>
ON WRITE (or delete, create, etc) OF TABLE REVERT.

 

[davidvilla]

But still the trigger exists with the table, isn't it? Can I permanently delete the trigger somehow?

 

[RealHeavyDude]

There are three options:

1. Go into the data dictionary and remove the path to the trigger. On the table properties window there is a button "triggers ...". You need to select the event for which you want to delete the triggers.
2. Delete the corresponding records in the _File-Trig table programatically

   FOR EACH _File
   WHERE _File._File-Name BEGINS {&Product}
   NO-LOCK TRANSACTION:
   
   FOR EACH _File-Trig
   WHERE _File-Trig._File-Recid = RECID (_File) EXCLUSIVE-LOCK:
   
   DELETE _File-Trig.
   
   END.

3. Create a delta definition with a database that does not have the triggers and load it into the database that does have the triggers.

Heavy Regards, RealHeavyDude.

 

[davidvilla]

Thanks.
I was looking for something like in the option 2 and I really like it.