|Subject||Re: [Firebird-Architect] Nulls in CHECK Constraints|
> What are the opinions about this? What does the standard say? What doOne other thing about our Check Constraints:
> other databases implement?
They allow access to other tables.
This is prohibited in the SQL (2003) standard, as a check constraint
should be a row constraint.
I guess this is an implementation error, given that Firebird check
constraints aren't evaluated completely if, for example, you delete
a row in the table.
The SQL standard says, I believe, that there's an "assertion" object
which can be used for table or database (multi-table) constraint.
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Database development questions? Check the forum!