Trigger type: one of the codes described following this table.ĮNABLED if the trigger is enabled DISABLED if the trigger is disabled.Ĭlause that must evaluate to TRUE for the trigger body ( TRIGGER_BODY) to execute.ĭescription of the trigger. Name of the table on which the trigger is defined.
Owner (schema) of the table on which the trigger is defined. C (Cascade) causes related child table rows to be deleted R (Restrict) prevents the deletion if any related child table rows exist.ĮNABLED if the referential integrity constraint is enabled DISABLED if the referential integrity constraint is disabled. Rule to apply when deletion occurs in the parent table. Name of the unique constraint defined on the parent table in the referential integrity constraint. List of foreign key columns in the parent table in the referential integrity constraint. List of foreign key columns in the child table in the referential integrity constraint. Name of the referential integrity constraint. Name of the parent table in the referential integrity constraint. Owner of the parent table in the referential integrity constraint. Name of the child table in the referential integrity constraint. Owner of the child table in the referential integrity constraint. NORMAL if the index is not a function-based index FUNCTION-BASED NORMAL for a function-based index. Name of the index used for enforcing the constraint. Owner of the index used for enforcing the constraint. Name of the table on which the constraint is defined.ĮNABLED if the constraint is enabled DISABLED if the constraint is disabled. One of the following values: P = primary constraint, PU = primary constraint enforced using unique index, PN = primary constraint enforced using non-unique index, U = unique constraint, UU = unique constraint enforced using unique index, UN = unique constraint enforced using non-unique index, UI = unique index.
0 kommentar(er)
