What does On Update/Delete 'Restrict' stand for?

TIA

Darrell

Darrell,

It indicates the type of referential action, i.e what should be done  to
enforce a referential integrity constraint.

The default action is NO ACTION but in EDB, NO ACTION is the same as
RESTRICT. It means that if the referential constraint is not satisfied
then no action is executed and EDB will raise an exception instead of
executing the UPDATE or DELETE.

SQL 2003 standard defines other possible referential actions but at
moment EDB only supports NO ACTION and RESTRICT and interprets them both
the same way.

--
Fernando Dias
[Team Elevate]