ReferentialAction in sqlparser::ast

ReferentialAction in sqlparser::ast - Rust

Enum ReferentialAction

pub enum ReferentialAction {
    Restrict,
    Cascade,
    SetNull,
    NoAction,
    SetDefault,
}

Expand description

<referential_action> = { RESTRICT | CASCADE | SET NULL | NO ACTION | SET DEFAULT }

Used in foreign key constraints in ON UPDATE and ON DELETE options.

RESTRICT - disallow action if it would break referential integrity.

CASCADE - propagate the action to referencing rows.

SET NULL - set referencing columns to NULL.

NO ACTION - no action at the time; may be deferred.

SET DEFAULT - set referencing columns to their default values.