Member Junction
    Preparing search index...

    Interface TriggerOptions

    Options for generating trigger DDL.

    interface TriggerOptions {
        body: string;
        events: ("INSERT" | "UPDATE" | "DELETE")[];
        forEach?: "ROW" | "STATEMENT";
        functionName?: string;
        schema: string;
        tableName: string;
        timing: "BEFORE" | "AFTER" | "INSTEAD OF";
        triggerName: string;
    }
    Index

    Properties

    body events forEach? functionName? schema tableName timing triggerName

    Properties

    body

    body: string

    The trigger body SQL

    events: ("INSERT" | "UPDATE" | "DELETE")[]

    Events that fire the trigger

    forEach?: "ROW" | "STATEMENT"

    Whether the trigger fires FOR EACH ROW or FOR EACH STATEMENT

    functionName?: string

    For PostgreSQL: name of the trigger function

    schema: string

    Schema name

    tableName: string

    Table name the trigger is on

    timing: "BEFORE" | "AFTER" | "INSTEAD OF"

    Timing: BEFORE, AFTER, or INSTEAD OF

    triggerName: string

    Trigger name

    Settings

    Member Visibility

    On This Page

    Properties