Progress
SQL-92
Guide and Reference


Trigger Basics

Use the SQL CREATE TRIGGER statement to create a trigger. This is the syntax for the CREATE TRIGGER statement.

SYNTAX
CREATE TRIGGER [ owner_name. ]trigname
  { BEFORE | AFTER }
  {  INSERT | DELETE | UPDATE [ OF column_name [ , ... ] }
ON table_name
  [ { OLDROW [ , NEWROW ] | NEWROW [ OLDROW ] } ]
  [ FOR EACH { ROW | STATEMENT }  ]
[ IMPORT  
      java_import_clause ] 
BEGIN
  java_snippet  
END 


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095