All pastes #578553 Raw Edit

Untitled

public sql v1 · immutable
·published 2007-06-20 09:56 UTC
rendered paste body
CREATE TRIGGER trigger-name trigger-time trigger-event [, trigger-event,...][ ORDER integer ] ON table-name[ REFERENCING [ OLD AS old-name ]                            [ NEW AS new-name ] ][ FOR EACH { ROW | STATEMENT } ][ WHEN ( search-condition ) ]trigger-time : BEFORE | AFTER | RESOLVEtrigger-event :DELETE | INSERT | UPDATE | UPDATE OF column-list