                     ----------  Create or Drop Trigger  ----------

 "create trigger" ޥɤϡơ֥˥ȥꥬޤ

:

  create  trigger TRIGGER | before |
                          | after  |
  
    |              delete                    | 
    |              insert                    | 
    | update [ of ( ATTR_NAME {, ATTR_NAME}) |
  
    { or |              delete                    | } 
         |              insert                    | 
         | update [ of ( ATTR_NAME {, ATTR_NAME}) |

    on TABLE [for each row [when CONDITION]]
    
    execute ROUTINE_NAME;

  "when"  CONDITION ϡ"where" ˻ȤΤƱͤǤ
  Ƥ°ϡȥꥬۤ졢"new." ޤ "old." ˸ꤵ줿
ơ֥ˤʤƤϤʤޤ󡣤ޤ꡼ΥͥȤϥݡȤƤޤ

ȥꥬˤϡ"drop trigger" ޥɤѤޤ

:

     drop trigger TRIGGER;


ȥꥬξܺپ򻲾ȤˤϰʲΥޥɤѤƲ:

                help display;

ȥꥬͭ/̵ޤϡ̤ͥѹˤĤƻȤˤϡʲ
ޥɤϤƲ:

                help alter;

