Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 2 of 2 total |
Constraint Parameters tab question |
Wed, Feb 25 2009 7:36 PM | Permanent Link |
Darrell | What does On Update/Delete 'Restrict' stand for?
TIA Darrell |
Wed, Feb 25 2009 8:07 PM | Permanent Link |
Fernando Dias Team Elevate | 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] |
This web page was last updated on Saturday, May 4, 2024 at 12:54 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |